一条sql语句如何查出所有文章和相对应的评论条数

两张表，一张文章吧，一张评论表，如何用一条sql语句查出所有文章和每篇文章对应的评论条数

 select article.* , 
       (select count(id) from reviews where reviews.article_id = article.id) as reviewsCount
from article
order by article.id

2表联查 用表ID

select w.* ,sum(p.id) from whenzhang w,pinglun p where w.id=p.wenzhangId group by w.id

select a.* ,count(c.cid) from articles(文章) a LEFT JOIN comments(评论) c ON a.aid=c.aid group by a.aid

SELECT a.id,COUNT(b.hit) from a LEFT JOIN b on a.id=b.id GROUP BY(a.id)

select 文章table， count（评论table） from 文章table，评论table where （看表里字段呢个关联着的，等于就行了）