Laravel Join и groupBy Не могут отображать данные столбцов

#php #laravel #php #ларавель Вопрос: $result = DB::table('students') -gt;join('cities', 'cities.id', '=', 'students.city_id' ) -gt;select('cities.city_name as CityStudent', DB::raw('COUNT(students.id) as total')) -gt;groupBy('cities.id')-gt;get(); view blade : @foreach($result as $r) lt;trgt; lt;tdgt;{{ $r-gt;CityStudent }}lt;/tdgt;…