Laravel で MongoDB を使用した複雑なクエリについて

composer require jenssegers/mongodb

$cityId = 1;//城市ID

$count = UserModel::query()->raw(function ($collection) use ($cityId) {

    $aggregate = [];

    $aggregate[]['$match'] = [

        'city_id' => intval($city_id),//过滤城市

        'sex' => ['$in' => [1,2]],//过滤性别

    ];

    $aggregate[]['$group'] = [

        '_id' => '$sex',//更具性别进行分组

        'avg_age' => [

            '$avg' => '$age',//查询年龄平均值

        ]

    ];

    //这里还可以继续添加各种条件

    return $collection->aggregate($aggregate)->toArray();

});