php - 如何统计每个用户发表的帖子总数

Question

我想统计每个成员发布的帖子总数，例如，

成员表，

member_id
1
2
3
4
5
6

张贴表格，

post_id         member_id
1               1
2               1
3               1
4               2
5               3

我追求的结果，

member_id       totalPost
1               3
2               1
3               1
4               0
5               0
6               0

我的工作查询，

SELECT *
FROM root_members_cfm  AS m

LEFT JOIN root_posts AS n
ON n.member_id = m.member_id

Answer 1

select
   count(post_id) as totalPost,
   m.member_id
from
   member as m 
left join 
   post on post.member_id=m.member_id 
group by m.member_id;