db={"modifieritems":[{"_id":ObjectId("5e6a5a0e6d40624b12453a67"),"modifierName":"xxx","isActive":1},{"_id":ObjectId("5e6a5a0e6d40624b12453a6a"),"modifierName":"yyy","isActive":0}],"favoritedrinks":[{"alcoholName":"whiskey","modifierList":[{"_id":ObjectId("5e6a5a0e6d40624b12453a61"),"modifierId":ObjectId("5e6a5a0e6d40624b12453a67"),"modifierName":"xxx",},{"_id":ObjectId("5e6a5a0e6d40624b12453a66"),"modifierId":ObjectId("5e6a5a0e6d40624b12453a6a"),"modifierName":"yyy",}]}]}

db.favoritedrinks.aggregate([{"$sort":{"alcoholName":1}},{"$lookup":{"from":"modifieritems",localField:"modifierList.modifierId",foreignField:"_id",as:"modifierStatus"}},{$addFields:{modifierStatus:{$map:{input:"$modifierList",as:"m",in:{$mergeObjects:[{$arrayElemAt:[{$filter:{input:"$modifierStatus",cond:{$eq:["$$this._id","$$m.modifierId"]}}},0]},"$$m"]}}}}},{$project:{modifierStatus:1,alcoholName:1,_id:0}}])