[{"_id":ObjectId("63a8808652f40e1d48a3d1d7"),"name":"A","description":null,"users":[{"id":"63a8808c52f40e1d48a3d1da","owner":"John Doe","purchase_date":"2022-12-25","status":"active","parent_user_id":"63a8808c52f40e1d48a3d1da"},{"id":"63a880a552f40e1d48a3d1dc","owner":"John Doe 1","purchase_date":"2022-12-25","parent_user_id":"63a8808c52f40e1d48a3d1da",},{"id":"63a880f752f40e1d48assddd","owner":"John Doe 2","purchase_date":"2022-12-25","parent_user_id":"63a8808c52f40e1d48a3d1da",},{"id":"63a880f752f40e1d48a3d207","owner":"John Doe 11","dt":"2022-12-25","status":"inactive","parent_user_id":"63a880f752f40e1d48a3d207",},{"id":"63a880f752f40e1d48agfmmb","owner":"John Doe 112","dt":"2022-12-25","status":"active","parent_user_id":"63a880f752f40e1d48agfmmb",},{"id":"63a880f752f40e1d48agggg","owner":"John SS","dt":"2022-12-25","status":"inactive","parent_user_id":"63a880f752f40e1d48agggg",},{"id":"63a880f752f40e1d487777","owner":"John SS","dt":"2022-12-25","parent_user_id":"63a880f752f40e1d48agggg",}]}]

db.collection.aggregate([{$addFields:{users_matched:{$filter:{input:"$users",as:"user",cond:{$eq:["active","$$user.status"],},},},},},{$set:{users:{$filter:{input:"$users",as:"user",cond:{$in:["$$user.parent_user_id","$users_matched.id"],},},},},},{$unset:"users_matched"}])