56,679
社区成员
发帖
与我相关
我的任务
分享
select A.groupid,A.groupname,count(B.userid)
from group A left join user B on A.groupid=B.parent
group by A.groupid,A.groupname
select u.parent as groupid ,(select g.groupname from Group g where g.groupid=u.parent limit 1 ) as groupname ,count(u.userid) as total from User u where 1 group by u.parent