public function updateMatchingQualify() { $results = DB::table('carries')->join('transactions', function ($join) { $join->on('carries.user_id', '=', 'transactions.user_id')->where('transactions.purpose', '=', 12); })->get(); foreach ($results as $result) { if ($result->left_carry != 0 || $result->right_carry != 0 && $result->matching_qualify != 1) { Carry::where('user_id', $result->user_id)->update(['matching_qualify' => 1]); } } }