Group By Eloquent ORM

Question

I was searching for making a GROUP BY name Eloquent ORM docs but I haven't find anything, neither on google.

Does anyone know if it's possible ? or should I use query builder ?

Answer 1

Eloquent uses the query builder internally, so you can do:

$users = User::orderBy('name', 'desc')                 ->groupBy('count')                 ->having('count', '>', 100)                 ->get(); 

Answer 2

Laravel 5

WARNING: As @Usama stated in comments section, this groups by AFTER fetching data from the database. The grouping is not done by the database server.
I wouldn't recommend this solution for large data set.

This is working for me (i use laravel 5.6).

$collection = MyModel::all()->groupBy('column'); 

If you want to convert the collection to plain php array, you can use toArray()

$array = MyModel::all()->groupBy('column')->toArray();