thinkphp中分页paginate和group by一起使用时 代码异常的解决办法

1. paginate和group by报错，代码如下，月份分组 $page = intval($where['page']); $limit = intval($where['limit']); $start_time = $where['start_time']; $end_time = $where['end_time']; $query = Db::table('eb_bonuslistlog') ->field('DATE_FORMAT(create_time,"%Y-%m") as date,SUM(money) as total_money,COUNT(*) as total_number') ->group('date') ->order('date desc'); if ($start_time && $end_time) { $query->whereTime('create_time', 'between', [date('Y-m-01 00:00:00', strtotime($start_time)), date('Y-m-t 23:59:59', strtotime($end_time))]); } $list = $query->paginate(15); return $list; 1. paginate和group by报错，代码如下，月份分组 $page = intval($