ThinkPHP5.1 group,page和count一起使用的问题

Question

sql语句简略
$sql = User::alias()->leftjoin()->field()->where();
$count = $sql->count();
$sql = $sql->order()->group()->page()->select();
return json(['code' => 200, 'msg' => '获取成功', 'data' => $sql, 'count' => $count]);

因前端需要总条数做分页
想 $count 返回的条数是要分组后的条数
而不是分组前的条数

大佬们，这个要怎么解决？

Answer 1

$sql = User::alias()->leftjoin()->field()->where()->order()->group();
$count = $sql->count();
$sql = $sql->page()->select();
return json(['code' => 200, 'msg' => '获取成功', 'data' => $sql, 'count' => $count]);