Database

db={items:[{_id:"7890",name:"item1"},{_id:"6543",name:"item2"}],orders:[{_id:"123456",name:"John Doe",items:[{item:"7890",count:4},{item:"6543",count:4}]}]}

Query

db.orders.aggregate([{"$lookup":{"from":"items","localField":"items.item","foreignField":"_id","as":"items_lookup"}},{"$project":{"name":1,"items":{"$map":{"input":"$items","as":"i","in":{"$mergeObjects":["$$i",{"name":{"$arrayElemAt":["$items_lookup.name",{"$indexOfArray":["$items_lookup._id","$$i.item"]}]}}]}}}}}])

Result