public function scopeCompany($query, $company_id) { $users = User::select('id')->get(); foreach ($users as $value) { $array[$value->id] = $value->id; } if ($company_id != "" && isset($array[$company_id])) { $query->where("company_id", $company_id); } }