public function showMap() { $projects = DB::table('projects')->take(10)->get(); $projects_all = Project::select('id', 'geo_lat', 'geo_lng')->hasGeo()->get(); $categories = Category::geocoded(); foreach ($categories as $key => $category) { $pivot = DB::table('project_category')->where('category_id', $category->id)->lists('project_id'); $categories[$key] = array_add($categories[$key], 'projects_pivot', $pivot); } $data = compact('projects', 'projects_all', 'categories'); return view('home.map', $data); }