Database

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")}]}

Query

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

Result