$datas = Db::name('store_admin')
->field('sa.id,sa.phone,sa.user_name,sa.created_time,sa.set_interval,s.store_admin_id,group_concat(s.store_name)as store_name,group_concat(s.store_status)as store_status,group_concat(s.create_time)as create_time,group_concat(s.is_check)as is_check,group_concat(s.store_id)as store_id,group_concat(s.is_official)as is_official,group_concat(s.store_validity)as store_validity')
->distinct('sa.id')
->alias('sa')
->order('id desc')
->where($where)
->group('s.store_admin_id')
->join('shop s', 'sa.id=s.store_admin_id', 'left')
->paginate($selectOptionPage);
最佳答案