Laravel, multiple aggregates in one column?

Question

Laravel

Hello! There is a table with a color(string) field, how to get the number of each color in one query?
The result is like this:
red 20
green 45
black 23

Answer 1

Dig mentioned in the comments
https://laravel.com/docs/8.x/queries#grouping
And pay attention to this:

->selectRaw('count(id) as number_of_orders, customer_id')