db={"coll":[{_id:"61c005f839d7239960dced76",people:[{id:"61c005b939d7239960dceca5",status:"pending"},{id:"6204232e0aa660002e2e2617",status:"active"}]},],"user":[{"_id":"61c005b939d7239960dceca5","firstName":"Joe","lastName":"Brandon",},{"_id":"6204232e0aa660002e2e2617","firstName":"John","lastName":"Apple",},]}

db.coll.aggregate([{$lookup:{from:"user",let:{people:"$people"},pipeline:[{$match:{$expr:{$in:["$_id","$$people.id"]}}}],as:"people2"}},{"$addFields":{"people":{$map:{input:"$people2",in:{"$mergeObjects":["$$this",{"$arrayElemAt":[{"$filter":{"input":"$people","as":"pstatus","cond":{$eq:["$$pstatus.id","$$this._id"]}}},0]}]}}}}}])