一个文章表,一个评论表,得到一个标题跟评论数的列表 SELECT a.title, COUNT(b.id) AS 'Comment Count' FROM fa_wo_page a LEFT JOIN fa_wo_comment b ON a.id = b.woid GROUP BY a.id