query("SELECT m.*, u.username FROM messages m JOIN users u ON m.user_id = u.id ORDER BY m.created_at ASC"); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); echo json_encode($messages);