public function no_assigned($user_id) { $no_assigned = EntrustRole::whereNotIn('id', function ($query) use($user_id) { $query->select(DB::raw('role_id'))->from('assigned_roles')->whereRaw("user_id = ?", array($user_id)); })->lists('name', 'id'); return $no_assigned; }