db={"users":[{"_id":ObjectId("5e2977e1cc1208c65c00648b"),"mappedShops":[ObjectId("5e2976cbcc1208c65c006488"),ObjectId("5e2976cbcc1208c65c00690c"),ObjectId("5e2976cbcc1208c65c006499")],"phoneNo":NumberLong(6789012345),"name":"acdbcs","address":"address 2","shopCode":"D3137","state":"M.P","city":"Indore"},{"_id":ObjectId("5e2fcf92d02e05b6949f8d9a"),"mappedShops":[ObjectId("5e2976cbcc1208c65c006411"),ObjectId("5e2976cbcc1208c65c00691b"),ObjectId("5e2976cbcc1208c65c006488")],"phoneNo":NumberLong(6789012345),"name":"acdbcs","address":"address 2","shopCode":"D3137","state":"M.P","city":"Indore"},{"_id":ObjectId("5e2976cbcc1208c65c006488"),"mappedShops":[ObjectId("5e2976cbcc1208c65c006800"),ObjectId("5e2976cbcc1208c65c006400")],"phoneNo":NumberLong(6789012388),"name":"acdbcs","address":"address 488","shopCode":"D3137","state":"M.P","city":"Indore"},{"_id":ObjectId("5e2976cbcc1208c65c00690c"),"mappedShops":[ObjectId("5e2976cbcc1208c65c006188"),ObjectId("5e2976cbcc1208c65c006188")],"phoneNo":NumberLong(6789012390),"name":"acdbcs","address":"address 90c","shopCode":"D3137","state":"M.P","city":"Indore"},{"_id":ObjectId("5e2976cbcc1208c65c006499"),"mappedShops":[ObjectId("5e2976cbcc1208c65c007889"),ObjectId("5e2976cbcc1208c65c006789")],"phoneNo":NumberLong(6789012399),"name":"acdbcs","address":"address 499","shopCode":"D3137","state":"M.P","city":"Indore"}],"orders":[{"_id":ObjectId("5e27f998a42d441fe8a8957f"),"isApproved":false,"orderCreatedOn":ISODate("2020-01-22T18:30:00.000Z"),"shopOrder":[],"frequency":"WE","orderCreatedBy":ObjectId("5e2976cbcc1208c65c00690c")},{"_id":ObjectId("5e2976cbcc1208c65c006481"),"isApproved":false,"orderCreatedOn":ISODate("2020-01-22T18:30:00.000Z"),"shopOrder":[],"frequency":"WE","orderCreatedBy":ObjectId("5e2976cbcc1208c65c006488")},{"_id":ObjectId("5e2fd0ffd02e05b6949fa769"),"isApproved":false,"orderCreatedOn":ISODate("2020-01-22T18:30:00.000Z"),"shopOrder":[],"frequency":"WE","orderCreatedBy":ObjectId("5e2976cbcc1208c65c006499")},{"_id":ObjectId("5e2fd10dd02e05b6949fa868"),"isApproved":false,"orderCreatedOn":ISODate("2020-01-22T18:30:00.000Z"),"shopOrder":[],"frequency":"WE","orderCreatedBy":ObjectId("5e2976cbcc1208c65c006400")}],"payments":[{"_id":ObjectId("5dd7900bcd00d33c245abbfa"),"paymentOfTheDay":400,"outstanding":200,"paymentDoneBy":ObjectId("5e2976cbcc1208c65c00690c")},{"_id":ObjectId("5e2fd13ad02e05b6949fac05"),"paymentOfTheDay":400,"outstanding":100,"paymentDoneBy":ObjectId("5e2976cbcc1208c65c006488")},{"_id":ObjectId("5e2fd177d02e05b6949fb1e7"),"paymentOfTheDay":400,"outstanding":300,"paymentDoneBy":ObjectId("5e2976cbcc1208c65c006499")}]}

db.users.aggregate([{$match:{_id:ObjectId("5e2977e1cc1208c65c00648b")}},{$lookup:{from:"users",localField:"mappedShops",foreignField:"_id",as:"mappedShops"}},{$unwind:"$mappedShops"},{$replaceRoot:{newRoot:"$mappedShops"}},{$lookup:{from:"orders",let:{mappedShopsId:"$_id"},pipeline:[{$match:{$expr:{$eq:["$orderCreatedBy","$$mappedShopsId"]}}},{$project:{orderCreatedOn:1,isApproved:1}}],as:"orders"}},{$lookup:{from:"payments",let:{mappedShopsId:"$_id"},pipeline:[{$match:{$expr:{$eq:["$paymentDoneBy","$$mappedShopsId"]}}},{$project:{outstanding:1}}],as:"payments"}},{$project:{name:1,phoneNo:1,address:1,shopCode:1,orders:1,payments:1}}])