@foreach($dists as $dist) @php $areas = \App\Areas::where('region_id',$dist->region_id)->select('id','area_name')->get(); $territories = \App\Territories::where('area_id',$dist->distributor_area_id)->select('id','territory_name')->get(); $cities = \Illuminate\Support\Facades\DB::table('area_assignment') ->join("cities","cities.id","=","area_assignment.city_id") ->where('area_assignment.area_id',$dist->distributor_area_id) ->groupBy('cities.id') ->select('cities.id','cities.name')->get(); @endphp {{$dist->id}} {{$dist->distributor_name}} ({{$dist->id}})
Update @endforeach