$res = M()
??????????? ->table(‘__USER__ u‘)
??????????? ->join(‘LEFT JOIN __USER_INFO__ i ON i.user_id=u.id‘)
??????????? ->where($where)
??????????? ->order($order)
??????????? ->limit($page,$page_num)
??????????? ->field($field)
??????????? ->group(‘u.id‘)
??????????? ->buildSql();
???????$countres = M()->table($res.‘a‘)-> group(‘id‘)->select();
???????$list[‘list‘] = $countres; //列表
???????$list[‘count‘] = count($countres); //数量
ThinkPHP group和count 无法同时使用解决办法
原文地址:https://www.cnblogs.com/soiq-1123/p/9356281.html