Database

db={"transactions":[{_id:ObjectId("5f1284078a7dd8a6b9140c97"),organization:ObjectId("5f127ce1e354f37df698f55e"),person:ObjectId("5f1284078a7dd8a6b9140c95"),actionTransaction:"Purchase","dateTransaction":"10/14/1994","sharesTransaction":40,"classTransaction":"Ordinary Shares with Voting Rights","pricePerShareTransaction":1250000,"paymentTypeTransaction":"Cash","sharePledgedTransaction":"No","pledgeNameTransaction":"","pledgeAddressTransaction":""},{_id:ObjectId("5f1284078a7dd8a6b8140c99"),organization:ObjectId("5f127de1e354f37ef698f55e"),person:ObjectId("5f1284078a7dd8a6b8140c93"),actionTransaction:"Purchase","dateTransaction":"10/14/1994","sharesTransaction":40,"classTransaction":"Ordinary Shares with Voting Rights","pricePerShareTransaction":1250000,"paymentTypeTransaction":"Cash","sharePledgedTransaction":"No","pledgeNameTransaction":"","pledgeAddressTransaction":""}],"organizations":[{_id:ObjectId("5f127ce1e354f37df698f55e"),name:"StackoverFlow Inc",members:[{_id:ObjectId("5f1284078a7dd8a6b9140c95"),"status":true,"title":"CEO","accessLevel":"organization_admin"},{_id:ObjectId("5f1284078a7ff8a6b9300d93"),"status":true,"title":"CTO","accessLevel":"organization_admin"}]},{_id:ObjectId("5f127de1e354f37ef698f55e"),name:"Google Inc",members:[]}],"people":[{_id:ObjectId("5f1284078a7dd8a6b9140c95"),fullName:"YuZi Foo",phoneNumber:"+111111111"},],}

Query

db.transactions.aggregate([{$lookup:{from:"organizations",localField:"organization",foreignField:"_id",as:"or",},},{$lookup:{from:"people",localField:"person",foreignField:"_id",as:"person",},},{"$unwind":{"path":"$person","preserveNullAndEmptyArrays":true}},{$group:{_id:"$_id",p:{$first:"$person._id"},or:{$first:{$arrayElemAt:["$or.members",0,]}},}},{$project:{out:{$filter:{input:"$or",cond:{$eq:["$$this._id","$p"]}}}}}])

Result