内部联接

您的连接语法错误.尝试:

SELECT *
FROM comments
INNER JOIN users ON comments.pooster = users.id
WHERE comments.content_id = '$id'
ORDER BY comments.date ASC