如果你对该文章中的内容有疑问/不解,可以点击此处链接提问
要注明问题和此文章链接地址 点击此处跳转
1 2 3 4 5 6 7 8 9 10 |
$list = Db::query("SELECT u.*, (select count(1) FROM zf_post where uid=u.id and `status`=1) as p_count, (select count(1) FROM zf_like where uid=u.id) as l_count, (select count(1) FROM zf_comment where uid=u.id) as c_count FROM zf_user u GROUP BY p_count+l_count+c_count DESC"); |