SELECT s.name as status, q.name as quality, p.name process, count(*) FROM plates JOIN equipment_status_codes s on equipment_status_code_id = s.id JOIN plate_qualities q on plate_quality_id = q.id JOIN processes p on process_id = p.id WHERE project_id in (SELECT id from projects WHERE name like 'SPIRIT') GROUP BY s.name, q.name, p.name ASC with ROLLUP

return Plate::select('equipment_status_codes.name as Status', 'plate_qualities.name as Quality', 'processes.name as Process')
    ->join('equipment_status_codes', 'plates.equipment_status_code_id', '=', 'equipment_status_codes.id')
    ->join('plate_qualities', 'plates.plate_quality_id', '=', 'plate_qualities.id')
    ->join('processes', 'plates.process_id', '=', 'processes.id')

    ->groupBy(DB::raw('equipment_status_code_id WITH ROLLUP'))
     ...
    ...
    ->get();