Database

db={local:[{_id:1},{_id:2},{_id:3}],metrics:[{_id:4,ownerIds:[1,2]},{_id:5,ownerIds:[3]}]}

Query

db.local.aggregate([{"$lookup":{"from":"metrics","as":"metrics","let":{"userId":"$_id"},"pipeline":[{"$match":{"$expr":{"$in":["$$userId","$ownerIds"]}}},{"$project":{"fieldName":1,"ownerIds":1,"auth0Cache":1}}],}}])

Result