laravel 查询部分字段或者多个聚合函数

方法一：get获取字段

get方法传入数组或者字符串字段

$list = MemberModel::where('group_id',3)->get([\DB::raw('count(id) as count_num'),\DB::raw('sum(money) as money_sum')])->toArray();



$list = MemberModel::where('group_id',3)->get(['id','username','nickname'])->toArray();

　　

方法二：select获取字段（传入数组或者字符串字段）

 

$list = MemberModel::where('group_id',3)->select([\DB::raw('count(id) as count_num'),\DB::raw('sum(money) as money_sum')])->get()->toArray();

$list = MemberModel::where('group_id',3)->select('id','name')->get()->toArray();
$users = DB::table('users') ->select(DB::raw('count(*) as user_count, status'))->where('status', '<>', 1)->groupBy('status')->get();

$list = MemberModel::where('group_id',3)->select(['id','name'])->get()->toArray();