How to group data from Mysql table in Laravel 5.1?

Question

Laravel

I figured out the table relationships and everything works out well, but I stumbled on the banal (
How to make two-dimensional arrays from one table .. sorry (
Actually there is a simple table - house id, street, house number
You need to get a two-dimensional array
street house id
1 house
id 2
like this Is it better to do it using Laravel?
As I understand it, you need to make a selection of the entire table - will you get a collection and already work with it?

Answer 1

Everything is very simple:

// ...
$result = MySuperTable::orderBy('blabla')->get()->groupBy('street');

$result will contain an object, call $result->all(); and get an array:

[
  'street1' => [house1, house2],
  'street2' => [house3, house4],
]