[{"_id":ObjectId("63a8808652f40e1d48a3d1d7"),"name":"A","description":null,"users":[{"id":"63a8808c52f40e1d48a3d1da","owner":"John Doe","purchase_date":"2022-12-25","status":"active","parent_user_id":"63a8808c52f40e1d48a3d1da","recent_items":["tomato","onion"]},{"id":"63a880a552f40e1d48a3d1dc","owner":"John Doe 1","purchase_date":"2022-12-25","parent_user_id":"63a8808c52f40e1d48a3d1da","recent_items":["onion"]},{"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","recent_items":["tomato"],},{"id":"63a880f752f40e1d48agggg","owner":"John SS","dt":"2022-12-25","status":"inactive","parent_user_id":"63a880f752f40e1d48agggg","recent_items":["oignon","tomato"]},{"id":"63a880f752f40e1d487777","owner":"John SS","dt":"2022-12-25","parent_user_id":"63a880f752f40e1d48agggg",}]}]

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