Getting table totals using Laravel Eloquent

query.php

<?php

$totals = DB::table('subscribers')
    ->addSelect(DB::raw('count(*) as all'))
    ->addSelect(DB::raw("sum(case when status = 'confirmed' then 1 else 0 end) as confirmed"))
    ->addSelect(DB::raw("sum(case when status = 'unconfirmed' then 1 else 0 end) as unconfirmed"))
    ->addSelect(DB::raw("sum(case when status = 'cancelled' then 1 else 0 end) as cancelled"))
    ->addSelect(DB::raw("sum(case when status = 'bounced' then 1 else 0 end) as bounced"))
    ->addSelect(DB::raw("sum(case when status = 'inactive' then 1 else 0 end) as inactive"))
    ->get();