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;
}
