select Name,id,num from User a left join (select count(*) num,UserID from bbs group by UserID) as b on a.ID=b.UserID
select count(id) as num,userid from bbs'视图的代码,名称起名为bbscount
select user.name,user.id,bbscount.num from user left join bbscount on bbscount.userid=user.id order by bbscount.num desc
28,390
社区成员
357,068
社区内容
加载中
试试用AI创作助手写篇文章吧