What is the best way to overwrite subquery on builder in laravel?

Question

Laravel

$query = Name::query()
  ->selectRaw('count(*) as subs, 
(SELECT count(*) FROM customers where active = 0 order by updated_at) as unsubs, sum(device = 1) as pc, 
sum(device = 0) mob');

That that I transfer in crude request the subquery does not look very good. Trying to understand better rewrite it

Answer 1

Use withCount with a closure - https://laravel.com/docs/5.7/eloquent-relationship...