db={"users":[{"_id":"60e6fd3616dd663e84a925e2","workerFirstName":"Firstaname","workerSurname":"lastname","workerId":"1","locationName":"location","workerDesignation":"designation","workerDepartment":"department",},{"_id":"60e6fd3616dd663e84a925e3","workerFirstName":"Firstaname1","workerSurname":"lastname1","workerId":"2","locationName":"location","workerDesignation":"designation","workerDepartment":"department",}],"canteens":[{"_id":"63b285b9e92eee614feb7be1","status":"LUNCH","Date":"2023-01-02T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e2"},{"_id":"63b2db8db10c24487201e0a2","status":"DINNER","Date":"2023-01-02T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e2"},{"_id":"63b39b247adbeb50bfbe3503","status":"BREAK FAST","Date":"2023-01-03T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e2"},{"_id":"63b3d248c076184fb07ff2c4","status":"LUNCH","Date":"2023-01-03T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e2"},{"_id":"63b42b8ccb57a4cb7af34015","status":"DINNER","Date":"2023-01-03T00:00:00.000Z"},{"_id":"63b4ef71e038498fe6634506","status":"BREAK FAST","Date":"2023-01-04T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e2"},{"_id":"63b285b9e92eee614feb7be2","status":"LUNCH","Date":"2023-01-02T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e3"},{"_id":"63b2db8db10c24487201e0a3","status":"DINNER","Date":"2023-01-02T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e3"},{"_id":"63b39b247adbeb50bfbe3504","status":"BREAK FAST","Date":"2023-01-03T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e3"},{"_id":"63b3d248c076184fb07ff2c5","status":"LUNCH","Date":"2023-01-03T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e3"},{"_id":"63b42b8ccb57a4cb7af34016","status":"DINNER","Date":"2023-01-03T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e3"},{"_id":"63b4ef71e038498fe6634507","status":"BREAK FAST","Date":"2023-01-04T00:00:00.000Z","employeeId":"60e6fd3616dd663e84a925e3"}]}

db.users.aggregate([{"$lookup":{"from":"canteens","localField":"_id","foreignField":"employeeId",pipeline:[{$match:{}},{$group:{_id:"$Date",id:{$first:"$_id"},status:{$push:"$status"}}},{$project:{_id:"$id",Date:"$_id",status:1}},],as:"canteenData",}}])