db={"category":[{"_id":1,"item":"Cat A",},{"_id":2,"item":"Cat B",},],"sticker":[{"_id":1,"item":"Sticker 1",},],"prefix":[{"_id":1,"item":"prefix 1",},],"store":[{"_id":1,"item":"Item 1","category_id":"1","sticker_id":"1","prefix_id":"1",},{"_id":2,"item":"Item 2","category_id":"2","sticker_id":"1","prefix_id":"1",},{"_id":3,"item":"Item 3","category_id":"1","sticker_id":"1","prefix_id":"1",},],}

db.category.aggregate([{$match:{_id:1,}},{$lookup:{"from":"store",let:{cid:{$toString:"$_id"}},pipeline:[{$match:{$expr:{$eq:["$category_id","$$cid"]}}},{$lookup:{from:"sticker",let:{sticker_id:"$sticker_id"},pipeline:[{$match:{$expr:{$eq:[{$toString:"$_id"},"$$sticker_id"]}}}],as:"stickerData"}},{$lookup:{from:"prefix",let:{prefix_id:"$prefix_id"},pipeline:[{$match:{$expr:{$eq:[{$toString:"$_id"},"$$prefix_id"]}}}],as:"prefixData"}},{$project:{_id:1,item:1,prefixData:{$first:"$prefixData"},stickerData:{$first:"$stickerData"}}}],as:"stores"}}])