@foreach($retailers as $retailer) @php $locality = \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 = \App\Cities::join('region_assignment_cities', function ($join) use ($dist) { $join->on('cities.id', '=', 'region_assignment_cities.city_id') ->where('region_assignment_cities.region_id',$dist->region_id); }) ->select('cities.id','cities.name')->get(); @endphp