select a.id,a.name.a.text,count(sub_a.id) from a join sub_a on a.id=sub_a.aid group by a.id,a.name.a.text
select a.* , isnull(t.cnt,0) [count] from a left join (select id , count(*) cnt from sub_a group by id) t on a.id = t.id
34,838
社区成员
254,632
社区内容
加载中
试试用AI创作助手写篇文章吧