MongoDB -如何使用深嵌套数组进行聚合

{
  "_id": ObjectId("5b28cab902f28e18b863bd36"),
  "name": "Premier League",
  "teams": [
    ObjectId("5b28cab902f28e18b863bd01"),
    ObjectId("5b28cab902f28e18b863bd02"),
    ObjectId("5b28cab902f28e18b863bd03"),
...

{
  "_id": ObjectId("5b28cab902f28e18b863bd01"),
  "name": "Liverpool",
  "players": [
    ObjectId('5b23tmb902f28e18b863bd01'),
    ObjectId('5b23tmb902f28e18b863bd02'),
    ObjectId('5b23tmb902f28e18b863bd03'),
...

{
  "_id": ObjectId("5b2b9a8bbda339352cc39ec1"),
  "name": "Mohamed Salah",
  "nationality": [
    ObjectId("5b23cn1902f28e18b863bd01"),
    ObjectId("5b23cn2902f28e18b863bd02"),
...

{
  "_id": ObjectId("5b23cn1902f28e18b863bd01"),
  "name": "England",
  "_id": ObjectId("5b23cn2902f28e18b863bd02"),
  "name": "Egypt",
...

{
  "divisions": [
      "_id": ObjectId("5b28cab902f28e18b863bd36"),
      "name": "Premier League",
      "teams": [
          "_id": ObjectId("5b28cab902f28e18b863bd01"),
          "name": "Liverpool",
          "players": [
              "_id": ObjectId("5b23tmb902f28e18b863bd01"),
              "name": "Mohamed Salah",
              "nationality": [
                  "_id": ObjectId("5b23cn2902f28e18b863bd02"),
                  "name": "Egypt",
                  "_id": ObjectId("5b23cn1902f28e18b863bd01"),
                  "name": "England",
      "_id": ObjectId("5b28cab902f28e18b863bd37"),
      "name": "Championship",
}

db.divisions.aggregate([
    $lookup: {
      from: 'teams',
      localField: 'teams',
      foreignField: '_id',
      as: 'teams'
])

db.division.aggregate([
    $lookup: {
      from: "teams",
      let: {
        teams: "$teams"
      pipeline: [
          $match: {
            $expr: {
              $in: [
                "$_id",
                "$$teams"
          $lookup: {
            from: "players",
            let: {
              players: "$players"
            pipeline: [
                $match: {
                  $expr: {
                    $in: [
                      "$_id",
                      "$$players"
                $lookup: {
                  from: "countries",
                  localField: "nationality",
                  foreignField: "_id",
                  as: "nationality"
            as: "players"
      as: "teams"
])

db.divisions.find(_id: division_id).populate(
    path: 'teams',
    populate: {
      path: 'players',

MongoDB -如何使用深嵌套数组进行聚合

2 个回答