Database

db={"products":[{"_id":0,"name":"product 0","desc":"some product","sales_reps":[{"sales_rep_id":0,"is_doing_good":true},{"sales_rep_id":1,"is_doing_good":true}]}],"sales_rep_master":[{"_id":0,"name":"sales rep 0"},{"_id":1,"name":"sales rep 1"},{"_id":2,"name":"sales rep 2"}]}

Query

db.products.aggregate([{$match:{_id:0,"sales_reps.is_doing_good":true}},{$unwind:"$sales_reps"},{$match:{"sales_reps.is_doing_good":true}},{$lookup:{from:"sales_rep_master",localField:"sales_reps.sales_rep_id",foreignField:"_id",as:"sales_reps"}},{$unwind:"$sales_reps"},{$addFields:{"sales_reps.doing_good":true}},{"$group":{"_id":"$_id","desc":{"$first":"$desc"},"name":{"$first":"$name"},"sales_reps":{"$push":"$sales_reps"}}}])

Result