SELECT comment_post_ID, count( * ) AS fc
FROM evo_comments
GROUP BY comment_post_id

以上可以，但如果写成select * from evo_posts a where a.ID in( SELECT comment_post_ID, count( * ) AS fc
FROM evo_comments
GROUP BY comment_post_id)
就会出错