如下
SELECT c.*,COUNT(a.id) AS 数量 FROM category AS c
LEFT JOIN article AS a
ON c.id=a.category_id
GROUP BY a.category_id查询一个文章分类包含几篇文章的SQL语句
{{ time }}
如下
SELECT c.*,COUNT(a.id) AS 数量 FROM category AS c
LEFT JOIN article AS a
ON c.id=a.category_id
GROUP BY a.category_id