How to count same values ​​in laravel 4 mysql table?

Question

Laravel

How to count same field values ​​in laravel 4 mysql table?
it is worth clarifying:
the values ​​of the field change over time, i.e. there is a table with a list of equipment models, which is supplemented and there is another table in which you need to calculate the number of each model.

Answer 1

Something like this:
Post::where('field', '1')->get()->count();

Answer 2

this helped:

$users = DB::table('users')
                     ->select(DB::raw('count(*) as user_count, status'))
                     ->groupBy('status')
                     ->get();