field('id,user_id')->select(); if (count($hs)){ foreach ($hs as $h){ $user = User::where('user_id',$h->user_id)->field('role,shop_id')->find(); if ($user){ if ($user->role == User::NORMAL_USER || $user->role == User::COMMISSION_USER){ $shopId = 0; }else{ $shopId = $user->shop_id; } BonusHistory::where('id',$h->id)->update(['shop_id'=>$shopId,'role'=>$user->role]); } } } } }