Database
db={Booking:[{"routeId":"6295f0836f9e32990d8b3485","date":"2022-06-02",},{"routeId":"6295f0836f9e32990d8b3485","date":"2022-06-03",},{"routeId":"6295f0836f9e32990d8b3486","date":"2022-06-02"},{"routeId":"6295f0836f9e32990d8b3487","date":"2022-06-03",}],Route:[{"Location":{"from":"6295f0986f9e32990d8b3488","to":"6295f0c06f9e32990d8b348b"},"_id":"6295f12c6f9e32990d8b348e","busId":"6295f0836f9e32990d8b3485","date":"2022-06-02","departureTime":11,"arrivalTime":12},{"Location":{"from":"6295f0986f9e32990d8b3488","to":"6295f0c06f9e32990d8b348b"},"_id":"6295f12c6f9e32990d8b348f","busId":"6295f0836f9e32990d8b3485","date":"2022-06-03","departureTime":10,"arrivalTime":9},{"Location":{"from":"6295f0986f9e32990d8b3488","to":"6295f0c06f9e32990d8b348b"},"_id":"6295f12c6f9e32990d8b349a","busId":"6295f0836f9e32990d8b3486","date":"2022-06-02","departureTime":8,"arrivalTime":6},{"Location":{"from":"6295f0986f9e32990d8b3488","to":"6295f0c06f9e32990d8b348b"},"_id":"6295f12c6f9e32990d8b349b","busId":"6295f0836f9e32990d8b3487","date":"2022-06-03","departureTime":7,"arrivalTime":5}]}
Query
db.Route.aggregate([{"$match":{"Location.from":"6295f0986f9e32990d8b3488","Location.to":"6295f0c06f9e32990d8b348b","date":"2022-06-02"}},{"$lookup":{"from":"Booking","localField":"busId","foreignField":"routeId","as":"bookings"}}])