记录一下修炼过程= =

 leaves_article是文章表

 leaves_articleClass是文章分类

查询出来分类下文章数量

查询所有分类以及此分类下的文章数量

select c.id,c.name,count(cid) as cnums from leaves_articleClass as c left join leaves_article as a on c.id=a.cid group by a.cid,c.id order by id asc