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

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",{"$arrayElemAt":[{"$filter":{"input":"$items_lookup","cond":{"$eq":["$$this._id","$$i.item"]}}},0]}]}}}}}])