db={"app":[{"_id":"6364da3dc6cded87a8d74084","name":"app1","provider_tenants":[{"_id":"6364871d84eedd81331c60eb","tenants":[{"path":"path1","_id":"6364872d84eedd81331c60ec",}]},{"_id":"63579dd4539180517fd51d71","tenants":[{"path":"path2","_id":"636485fa84eedd81331c60e6"}]}]}],"details_provider":[{"_id":"63579dd4539180517fd51d71","name":"details_aaaaaa","tenants":[{"name":"xxxxx","redirect_uri":"www.asdf.com","_id":"636485fa84eedd81331c60e6"},{"name":"zzzzz","redirect_uri":"www.zxcv.com","_id":"6364860684eedd81331c60e7"}]},{"_id":"6364871d84eedd81331c60eb","name":"details_bbbbbb","tenants":[{"name":"yyyyy","redirect_uri":"www.qwer.com","_id":"6364872d84eedd81331c60ec"}]}]}

db.app.aggregate([{$lookup:{from:"details_provider",localField:"provider_tenants._id",foreignField:"_id",as:"provider"}},{"$project":{"name":1,"provider_tenants":{"$map":{"input":"$provider_tenants","as":"ps",in:{$mergeObjects:["$$ps",{$arrayElemAt:[{$filter:{input:"$provider",cond:{$eq:["$$this._id","$$ps._id"]}}},0]}]}}}}}])