Laravel, grouping via groupby(). How to return an array containing id?

Question

Laravel

Good afternoon.
There is a query
$ret = User::select('id')->groupBy('age')->get();
Groups norms, but you need to get arrays with user ids as a result:
[1,3,8,9],[2,4,5,7],[6,10].....
Tell me how to do this. Thank you!

Answer 1

$users = User::select(DB::raw('GROUP_CONCAT(id) as id'))->groupBy('age')->get();
$groups = $users->map(function ($item, $key) {
  return explode(',', $item['id']); // Возможно здесь ошибся
});

Answer 2

Something like this (crutch):

$ret = User::select('id', 'age')->get()->groupBy('age')->map(function ($item) { return $item->pluck('id'); } )->toArray();