db={cart:[{"_id":{"$oid":"6592be024fc8de3f1771a9e1"},"product":{"$oid":"657fab1586f102e3657bf034"},"user":{"$oid":"6559696bfa9b7df357161a81"},"createdAt":{"$date":"2024-01-01T13:28:34.452Z"},"unit":4,"updatedAt":{"$date":"2024-01-01T13:28:46.865Z"}},{"_id":{"$oid":"6592dc014fc8de3f1771bc3f"},"product":{"$oid":"65801d5e2c366e8773ada21f"},"user":{"$oid":"6559696bfa9b7df357161a81"},"createdAt":{"$date":"2024-01-01T15:36:33.420Z"},"unit":3,"updatedAt":{"$date":"2024-01-01T15:36:37.161Z"}}],users:[{"_id":{"$oid":"6559696bfa9b7df357161a81"},"name":"bob","email":"bob@gmail.com","password":"secret1"},{"_id":{"$oid":"6559696bfa9b7df357161a22"},"name":"sally","email":"sally@gmail.com","password":"secret123"}],products:[{"_id":{"$oid":"657fab1586f102e3657bf034"},"title":"Hat","short_des":"Red baseball cap","price":99},{"_id":{"$oid":"65801d5e2c366e8773ada21f"},"title":"Scarf","short_des":"Green tartan scarf","price":25}]}

db.cart.aggregate([{$match:{user:ObjectId("6559696bfa9b7df357161a81")}},{$lookup:{from:"users",localField:"user",foreignField:"_id",as:"userDetails"}},{$unwind:"$userDetails"},{$lookup:{from:"products",localField:"product",foreignField:"_id",as:"productDetails"}},{$unwind:"$productDetails"},{$group:{_id:"$userDetails._id",carts:{$push:{cart_id:"$_id",product:"$productDetails",unit:"$unit",user:"$userDetails"}}}},{$project:{_id:0,unit:1,"carts.cart_id":1,"carts.product":{price:1,title:1},"carts.user":{email:1,name:1}}}])