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"}}]}},])

Result