db={"products":[{"_id":"6402ec724db3304dfc134069","name":"product Name","stores":[{"_id":"63f43de1b8604ed5c5c99f02","name":"Store Name","package":[{"name":"package name","_id":"63f43e9eb8604ed5c5c99f48"}]}]}],"storages":[{"_id":"63f43de1b8604ed5c5c99f02","StorageName":"Storage Name","region":[{"name":"region name","_id":"63f43e9eb8604ed5c5c99f48","skus":[{"name":"first sku","variant":[{"name":"variant name"},{"name":"variant name"},{"name":"variant name"},{"name":"variant name"},],"_id":"63f4c734b8604ed5c5c99f99"},{"name":"sec sku","variant":[{"name":"variant name"},{"name":"variant name"},{"name":"variant name"},{"name":"variant name"},],"_id":"63f4c73ab8604ed5c5c99fa7"},{"name":"third sku","_id":"6402baac4db3304dfc133db7"}]},{"name":"region name","_id":"63f43ea9b8604ed5c5c99f5b","skus":[{"name":"first sku","_id":"63f4db42cfb1ebe9fafc1ff0"},{"name":"sec sku","_id":"63f4db4dcfb1ebe9fafc200a"},{"name":"third sku","_id":"63f4db5ccfb1ebe9fafc2027"}]}],}]}

db.products.aggregate([{"$match":{"_id":"6402ec724db3304dfc134069",}},{"$unwind":"$stores"},{$lookup:{from:"storages",let:{storeID:{"$toString":"$stores._id"}},pipeline:[{$match:{$expr:{$eq:["$_id","$$storeID"]}}},{$project:{"name":"$StorageName","package":{"$filter":{"input":{"$map":{"input":"$region","as":"region","in":{"_id":"$$region._id","name":"$$region.name","sku":{"$filter":{"input":"$$region.skus","as":"sku","cond":{$eq:["$$sku._id","63f4c734b8604ed5c5c99f99",]}}}}}},"as":"region","cond":{"$ne":["$$region.sku",[]]}}},},}],as:"stores"}},])