一条模型语句查询出不同状态数量

 $store = $model->field($field)
            ->with(['banner', 'station' => function ($query) {
                $query->field(['store_id', DB::raw('SUM(IF(status = 1, 1, 0)) as working_count'), DB::raw('count(status) as all_count'),
                    DB::raw('SUM(IF(status = 0, 1, 0)) as rest_count')])->group('store_id')->hidden(['status', 'work_station']);
            },])->order('create_time', 'desc')
            ->paginate($data)->each(function ($query) {
                $query->station->each(function ($station) use (&$query) {
                    $query->working_count_number = $station->working_count ?? 0;
                    $query->all_count_number = $station->all_count ?? 0;
                    $query->rest_count_number = $station->rest_count ?? 0;
                });
            });

使用Db::raw('SUM(if(status=1,1,0)) as working_status') Db::raw(‘sum(if(status=0,1,0)) as rest_count’)