db={setting:[{"_id":ObjectId("5c4ee7eea4affa32face874b"),"name":"Dave","deleted_at":0,"status":true,"createdAt":ISODate("2019-01-28T11:30:54.370Z"),"updatedAt":ISODate("2020-05-29T09:06:31.117Z"),"attempt_time":ISODate("2020-05-29T09:06:31.116Z")},{"_id":ObjectId("5ebf891245aa27c290672325"),"name":"Menz","deleted_at":0,"status":true,"createdAt":ISODate("2020-05-16T06:32:50.295Z"),"updatedAt":ISODate("2020-05-29T09:10:38.276Z"),"attempt_time":ISODate("2020-05-29T09:10:38.275Z")}],site:[{"_id":ObjectId("5ed0e90a33e6b961574920dc"),"order_id":ObjectId("5ecf99bf0a57ad5c15338524"),"admin_id":ObjectId("5c4ee7eea4affa32face874b"),"createdAt":ISODate("2020-05-29T10:50:50.110Z"),"updatedAt":ISODate("2020-05-29T10:50:50.110Z")},{"_id":ObjectId("5ed0e90a33e6b961574920de"),"order_id":ObjectId("5ecf99bf0a57ad5c15338524"),"admin_id":ObjectId("5c4ee7eea4affa32face874b"),"createdAt":ISODate("2020-05-29T10:50:50.110Z"),"updatedAt":ISODate("2020-05-29T10:50:50.110Z")}]}

db.setting.aggregate([{$match:{status:true,deleted_at:0,_id:{$in:[ObjectId("5c4ee7eea4affa32face874b"),ObjectId("5ebf891245aa27c290672325")]}}},{$lookup:{from:"site",localField:"_id",foreignField:"admin_id",as:"data"}},{$unwind:{path:"$data",preserveNullAndEmptyArrays:true}},{$group:{_id:"$_id",name:{$first:"$name"},status:{$first:"$status"},numberOfRecord:{$sum:{$cond:{if:{$gte:["$data.createdAt",new Date("2020-01-01")]},then:1,else:0}}}}},{$sort:{numberOfRecord:1}}])