調(diào)用會(huì)員在某個(gè)數(shù)據(jù)表發(fā)帖量的排行，沒(méi)有發(fā)布信息的會(huì)員按照會(huì)員ID排序

sql：

select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember u group by u.userid order by myorder desc,u.userid asc

效果圖：