56,677
社区成员
发帖
与我相关
我的任务
分享
select tb.groupid,tb.name,count(distinct tc.id) as kehuqty
from (select id,groupid from kehu where id = '???') ta
inner join groups tb
on ta.groupid = tb.id
inner join kehu tc
on tb.id = tc.groupid
group by tb.groupid,tb.name;