Database

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

Query

db.favoritedrinks.aggregate([{"$sort":{"alcoholName":1}},{$lookup:{from:"modifieritems",let:{id:"$modifierList.modifierId"},pipeline:[{$match:{$expr:{$in:["$_id","$$id"]}}},{$addFields:{modifierId:"$_id"}}],as:"modifierStatus"}},{$project:{"modifierList":0,_id:0}}])

Result