header('Content-type: application/json');
$db = new mysqli('localhost', 'root', '', 'db_adi');
$db->query('SET NAMES utf8');

$data = $tickets = array();

$query = $db->query('SELECT * FROM tickets WHERE user_id = ' . $user_id);
while ($row = $query->fetch_object()) {
    $data[$id] = array(
        'id' => $row->id,
        'user_id' => $row->user_id,
        'user_mail' => $row->user_mail,
        'user_title' => $row->title,
        'message' => $row->message,
        'status' => $row->status,
        'created' => $row->created,
        'comments' => array()
    );

    array_push($tickets, $row->id);
}

$query = $db->query('SELECT * FROM ticket_comments WHERE ticket_id IN(' . join(', ', $tickets) . ')');
while ($row = $query->fetch_object()) {
    $data[$row->ticket_id]['comments'][] = $row;
}

exit(json_encode($data, JSON_NUMERIC_CHECK));