[{"pid":"123","title":"title1","user":[{"id":"user1","title":"title1 user1","jobs":[{"id":"123","status":"Active"},{"id":"456","status":"Active"}]},{"id":"user2","title":"title1 user2","jobs":[{"id":"123","status":"Inactive"},{"id":"456","status":"Active"}]}]},{"pid":"456","title":"title1","user":[{"id":"user1","title":"title1 user1","jobs":[{"id":"123","status":"Active"},{"id":"456","status":"Inactive"}]},{"id":"user2","title":"title1 user2","jobs":[{"id":"123","status":"Inactive"},{"id":"456","status":"Inactive"}]}]},{"pid":"789","title":"title1","user":[{"id":"user1","title":"title1 user1","jobs":[{"id":"789","status":"Active"},{"id":"456","status":"Inactive"}]},{"id":"user2","title":"title1 user2","jobs":[{"id":"789","status":"Active"},{"id":"456","status":"Inactive"}]}]}]

db.collection.aggregate([{$set:{user:{$map:{input:"$user",as:"user",in:{$mergeObjects:["$$user",{jobs:{$filter:{input:"$$user.jobs",as:"job",cond:{$and:[{$ne:["$$job.status","Active"]},{$eq:["$$job.id","$pid"]}]}}}}]}}}}},{$set:{user:{$filter:{input:"$user",cond:{$ne:["$$this.jobs",[]]}}}}},{$match:{user:{$ne:[]}}}])