/** * Get districts that belong to the city/province by city_id * * @param int $id City id * * @return \Illuminate\Support\Collection $collection */ protected function _getWardsByCityId($id) { $dbRaw = DB::raw("id, CONCAT(type, ' ', name) as name"); $wards = Ward::where('district_id', $id)->select($dbRaw)->orderBy('name')->get(); return $wards; }