分类表admin_news_class:

id, name
---------
1   cat1
2   cat2
3   cat3
4   cat4

id, cid, title
--------------
1   1    title1
2   3    title2
3   1    title3
4   2    title4

+-------+-------+
|  name | count |
+-------+-------+
|  cat1 |     2 |
|  cat2 |     1 |
|  cat3 |     1 |
|  cat4 |     0 |
+-------+-------+

SELECT c.classname,(select count(*) from admin_news where classid = c.id) as count  FROM admin_news_class c WHERE 1 GROUP BY c.id


php - MySQL中如何选择所有类别并统计每个类别文章的数量代码结束