select a.aID,a.aName,IFNULL(count(*),0) as bCount from A left join B on a.aID=b.aID group by a.aID,a.aName
select a.aID,a.aName,count(*) as bCount from A left join B on a.aID=b.aID group by a.aID,a.aName
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧