[{"workerId":"1005","shiftListData":[{"_id":"63875e8182ebbe13ee9531d4","shiftCode":"HOBGS_1100","date":"2022-12-31T00:00:00.000Z"},{"_id":"63b277a2f6a8eccb2d95d407","shiftCode":"WO","date":"2023-01-01T00:00:00.000Z"},{"_id":"63b27787f6a8eccb2d95cf30","shiftCode":"HOBGS_1100","date":"2023-01-02T00:00:00.000Z"},{"_id":"63b277a2f6a8eccb2d95d409","shiftCode":"HOBGS_1100","date":"2023-01-03T00:00:00.000Z"}],"attendances":[{"_id":"61307cd385b5055a15cec159","Date":"2022-12-31T00:00:00.000Z","inTime":"2022-12-31T11:16:10.000Z","name":"name2"},{"_id":"63b236ef3980cffaf7715d62","inTime":"2023-01-02T07:14:08.000Z","Date":"2023-01-02T00:00:00.000Z","name":"name2"}]},{"workerId":"1006","shiftListData":[{"_id":"63875e8182ebbe13ee9531d2","shiftCode":"HOBGS_1100","date":"2022-12-31T00:00:00.000Z"},{"_id":"63b277a2f6a8eccb2d95d403","shiftCode":"WO","date":"2023-01-01T00:00:00.000Z"},{"_id":"63b27787f6a8eccb2d95cf39","shiftCode":"HOBGS_1100","date":"2023-01-02T00:00:00.000Z"},{"_id":"63b277a2f6a8eccb2d95d400","shiftCode":"HOBGS_1100","date":"2023-01-03T00:00:00.000Z"}],"attendances":[{"_id":"61307cd385b5055a15cec158","Date":"2022-12-31T00:00:00.000Z","inTime":"2022-12-31T11:16:10.000Z","name":"name"},{"_id":"63b236ef3980cffaf7715d69","inTime":"2023-01-02T07:14:08.000Z","Date":"2023-01-02T00:00:00.000Z","name":"name"}]}]

db.collection.aggregate([{$set:{shiftListData:{$map:{input:"$shiftListData",as:"shift",in:{$mergeObjects:["$$shift",{$ifNull:[{$first:{$filter:{input:"$attendances",cond:{$eq:["$$this.Date","$$shift.date"]}}}},{}]}]}}},attendances:"$$REMOVE"}}])