//where关联条件
->when($by_income, function ($query) use ($by_income) { //when 方法
$query->whereHas('incomeuser', function ($query) use ($by_income) { //whereHas //incomeuser是关联的模型名
$query->where('by_income',$by_income);
});
})
//sum 关联求和
->with(['incomedetails'=>function($d){
$d->groupBy('user_id')->whereIn('income_type',['recharge','viprecharge','srecharge'])
->selectraw('user_id ,sum(income) as recharge_income');
}])