来自多列的Laravel Elequent计数

// 假设我们有一个名为users的表，包含了status和gender两个列

// 使用查询构建器进行多列计数
$count = DB::table('users')
            ->select(DB::raw('COUNT(*) as total, SUM(CASE WHEN status = "active" THEN 1 ELSE 0 END) as active_count, SUM(CASE WHEN gender = "male" THEN 1 ELSE 0 END) as male_count'))
            ->first();

$totalCount = $count->total; // 总数
$activeCount = $count->active_count; // status为active的数量
$maleCount = $count->male_count; // gender为male的数量

// 使用Eloquent模型进行多列计数
class User extends Model
{
    protected $table = 'users';
}

$totalCount = User::count(); // 总数
$activeCount = User::where('status', 'active')->count(); // status为active的数量
$maleCount = User::where('gender', 'male')->count(); // gender为male的数量