db={"orders":[{"_id":ObjectId("614415f4a6566a001623b622"),"record":[{"dateTime":ISODate("2021-09-17T04:13:39.465Z"),"status":"time-in","month":9,"day":17,"year":2021,"time":1631852019465.0,"date":ISODate("2021-09-17T00:00:00.000Z"),},{"dateTime":ISODate("2021-09-17T04:14:01.182Z"),"status":"time-out","month":9,"day":17,"year":2021,"time":1631852041182.0,"date":ISODate("2021-09-17T00:00:00.000Z"),}],"uid":ObjectId("614415b0a6566a001623b80b"),"date":ISODate("2021-09-17T00:00:00.000Z"),"status":"time-out","createdAt":ISODate("2021-09-17T04:13:40.102Z"),"updatedAt":ISODate("2021-09-17T04:14:01.831Z"),"__v":0}],"users":[{"_id":ObjectId("614415b0a6566a001623b80b"),"displayName":"test test","firstName":"test","lastName":"test","email":"test@gmail.com","brand":"Jollibee","phone":"+632312312312312","role":1,"isVerified":true,"isArchived":false,"createdAt":ISODate("2021-10-05T08:40:13.208Z"),"updatedAt":ISODate("2021-10-05T08:40:13.208Z"),"__v":0}]}

db.users.aggregate([{"$match":{brand:"Jollibee"}},{$lookup:{from:"orders",let:{id:"$_id"},pipeline:[{$match:{date:{$gte:ISODate("2020-11-01"),$lt:ISODate("2021-11-30")},$expr:{$eq:["$uid","$$id"]}}}],as:"orders",},},{$project:{"_id":1,"name":1,"orders":1}}])