db={"users":[{"companyId":{"$oid":"635c70892e8cfaf4a7d49a3f"},"memberId":{"$oid":"635d31a5064a0392acef63b2"},"isActive":false,"name":"STUDENT 1","profileImage":"string","email":"some@mail.com","phone":"08712345678","regDate":{"$date":{"$numberLong":"1667001600000"}},"mainClassId":{"$oid":"635d2e398e7b6138e9a65111"},"classId":{"$oid":"635d2f796804b95ce6a9e5d1"},"tags":[],},{"companyId":{"$oid":"635c70892e8cfaf4a7d49a3f"},"memberId":{"$oid":"635d31a5064a0392acef63b2"},"isActive":false,"name":"STUDENT 2","profileImage":"string","email":"some@mail.com","phone":"08712345678","regDate":{"$date":{"$numberLong":"1667001600000"}},"mainClassId":{"$oid":"635d2e398e7b6138e9a65111"},"classId":{"$oid":"635d2f836804b95ce6a9e5d2"},"tags":[],},{"companyId":{"$oid":"635c70892e8cfaf4a7d49a3f"},"memberId":{"$oid":"635d31a5064a0392acef63b2"},"isActive":false,"name":"STUDENT 3","profileImage":"string","email":"some@mail.com","phone":"08712345678","regDate":{"$date":{"$numberLong":"1667001600000"}},"mainClassId":{"$oid":"635d2e398e7b6138e9a65111"},"classId":{"$oid":"635d2f8e6804b95ce6a9e5d3"},"tags":[],},{"companyId":{"$oid":"635c70892e8cfaf4a7d49a3f"},"memberId":{"$oid":"635d31a5064a0392acef63b2"},"isActive":false,"name":"STUDENT 4","profileImage":"string","email":"some@mail.com","phone":"08712345678","regDate":{"$date":{"$numberLong":"1667001600000"}},"mainClassId":{"$oid":"635d2e398e7b6138e9a65111"},"classId":{"$oid":"635d2f966804b95ce6a9e5d4"},"tags":[],},],"tbl_classes":[{"_id":{"$oid":"635d2e398e7b6138e9a65111"},"isDelete":false,"companyId":{"$oid":"635c70892e8cfaf4a7d49a3f"},"isActive":true,"mainClass":"VII","classes":[{"classId":{"$oid":"635d2f6e6804b95ce6a9e5d0"},"className":"A","classCode":"VII A","tags":[]},{"classId":{"$oid":"635d2f796804b95ce6a9e5d1"},"className":"B","classCode":"VII B","tags":[]},{"classId":{"$oid":"635d2f836804b95ce6a9e5d2"},"className":"C","classCode":"VII C","tags":[]},{"classId":{"$oid":"635d2f8e6804b95ce6a9e5d3"},"className":"D","classCode":"VII D","tags":[]},{"classId":{"$oid":"635d2f966804b95ce6a9e5d4"},"className":"E","classCode":"VII E","tags":[]}]}]}

db.users.aggregate([{"$match":{"companyId":ObjectId("635c70892e8cfaf4a7d49a3f")}},{"$lookup":{"from":"tbl_classes","localField":"mainClassId","foreignField":"_id","as":"kelas"}},{"$unwind":"$kelas"},{"$project":{"name":1,"classId":1,"email":1,"phone":1,"regDate":{"$dateToString":{"date":"$regDate","format":"%d/%m/%Y"}},"tags":1,"filteredClasses":{"$filter":{"input":"$kelas.classes","as":"classes","cond":{"$eq":["$classId","$$classes.classId"]}}}}}])