$re=WechatChat::with(['userInfo'=>function($query){ $query->select('openid', 'nickname','headimgurl'); }])->where($where)->where('read',1) ->select('openid','id',DB::raw('max(add_time) as add_time')) ->orderBy('id','desc')->groupBy('openid')->paginate(50)->toarray();
select里面添加个原生语句DB::raw('max(add_time) as add_time') 根据添加的时间进行排序