db={"user":[{"_id":1,"email":"abc@gmail.com","name":"Jane","roles":[1]},{"_id":2,"email":"pqr@gmail.com","name":"Derek","roles":[2]},{"_id":3,"email":"xyz@gmail.com","name":"John","roles":[3]}],"role":[{"_id":1,"name":"Admin"},{"_id":2,"name":"User"},{"_id":3,"name":"SuperAdmin"}]}

db.user.aggregate([{$lookup:{from:"role",localField:"roles",foreignField:"_id",as:"roles"}},{$match:{"roles.name":{$in:["Admin","SuperAdmin"]}}},{$project:{_id:0,name:1,IsSuperAdmin:{$cond:[{$eq:["$roles.name",["SuperAdmin"]]},"YES","NO"]}}}])