public function getDashboard() { $users = User::leftJoin('usergroups', 'users.group_id', '=', 'usergroups.id')->select('users.*', 'users.id as user_id', 'usergroups.nombre as nombre_g')->get(); $sedes = Sedes::leftJoin('sedes_users', 'sedes.id', '=', 'sedes_users.sede_id')->select('user_id', DB::raw('GROUP_CONCAT(sedes.nombre SEPARATOR ", ") as sedes_p'))->groupBy('user_id')->lists('sedes_p', 'user_id'); return View::make('users.dashboard')->with(array('users' => $users, 'sedes' => $sedes)); }