MongoDB inserting child document on ID reference-CodePudding

I migrated my SQL database into a MongoDB database for a project. It migrated the foreign keys as the ID's that were already there. For example I have these two columns linked through the driversId:

My question is how do I get the driver as a document in the driver_standings collection? Thanks in advance!

Edit: I've used the answer below with $merge to update the collection:

db.driverstandings.aggregate([{
  $lookup: {
    from: "drivers",
    localField: "driverId",
    foreignField: "driverId",
    as: "driver"
  }
}, { $merge: { into:"driverstandings" } }
])

CodePudding user response：

use $lookup aggregation operator

db.driver_standings.aggregate([{
  $lookup: {
    from: "drivers",
    localField: "driverId",
    foreignField: "driverId",
    as: "driver"
  }
}])