How to write such a query using laravel eloquent?

Question

Laravel

There is this request:

SELECT auto.*, count(parts.id) as total
FROM auto
LEFT JOIN parts ON auto.id = parts.auto_id
GROUP BY auto.id

Can such a query be adapted to laravel eloquent?

Answer 1

DB::table('auto')
                     ->select('auto.*', DB::raw('count(parts.id) as total'))
                     ->join('parts', 'auto.id', '=', 'parts.auto_id')
                     ->groupBy('auto.id')
                     ->get();

Answer 2

App\Auto::withCount('parts')->get()
https://laravel.com/docs/5.4/eloquent-relationship...