Database
[{"_id":ObjectId("623ec44a6900ca5e3a88ece0"),"student_id":ObjectId("5fca683c239e4e2693ee20e4"),"isSession":true,"record_list":[{"_id":ObjectId("623ec4ae319ebd3d243adeb4"),"Name":"Adam","Type":1,"class_id":"aa0a2311-5989-4a7b-855f-4c4b73ae6315","isPresent":true},{"_id":ObjectId("623ec4ae319ebd3d243adeb5"),"Name":"Jack","Type":1,"class_id":"fa54389b-4504-465b-9c6c-a386918b8d67","isPresent":true}]},{"_id":ObjectId("623ec44a6900ca5e3a88ece1"),"student_id":ObjectId("5fca683c239e4e2693ee20e4"),"isSession":true,"record_list":[{"_id":ObjectId("623ec4ae319ebd3d243adeb4"),"Name":"Adam","Type":1,"class_id":"aa0a2311-5989-4a7b-855f-4c4b73ae6315","isPresent":true},{"_id":ObjectId("623ec4ae319ebd3d243adeb5"),"Name":"Jack","Type":1,"class_id":"fa54389b-4504-465b-9c6c-a386918b8d67","isPresent":true}]}]
Query
db.collection.aggregate([{$match:{"student_id":ObjectId("5fca683c239e4e2693ee20e4")}},{"$addFields":{"record_list":{"$filter":{"input":"$record_list","as":"rec","cond":{$eq:["$$rec.class_id","fa54389b-4504-465b-9c6c-a386918b8d67"]}}}}}])