Database

db={"users":[{"name":"","email":"","phone":"","city":"","customerID":""}],"ships":[{"address":"","city":"","pincode":"","porderID":"","customerID":""}],"orders":[{"productName":"","quantity":"","pricing":"","mrp":"","porderID":"","customerID":""}]}

Query

db.users.aggregate([{"$lookup":{"from":"orders","localField":"customerID","foreignField":"customerID","as":"BuyOrder","pipeline":[{"$lookup":{"from":"ships","localField":"customerID","foreignField":"customerID","as":"ShipmentDetail"}}]}},{"$project":{"_id":0,"city":0,"email":0,"phone":0,"name":0,"BuyOrder":{"_id":0,"mrp":0,"customerID":0,"ShipmentDetail":{"_id":0,"customerID":0,"porderID":0}}}}])

Result