[{"WorkspaceId":"er890we8rw98ro9we8rjower","WorkspaceTitle":"My First Workspace","WorkspaceOwner":"user1","Pages":[{"PageId":"a1sd32as7d841a23sd","PageMembers":[{"MemberId":"user1","MemberName":"John","MemberAvatar":"https://example.com/jKLa29Wqy","MemberAccess":"can edit"},{"MemberId":"user2","MemberName":"Margot","MemberAvatar":"https://example.com/wKKLSAqy","MemberAccess":"can edit"},{"MemberId":"user3","MemberName":"Silvia","MemberAvatar":"https://example.com/wKKLSAqy","MemberAccess":"can edit"}]}]}]

db.collection.aggregate([{"$unwind":"$Pages"},{$addFields:{"Pages.PageMembers":{$filter:{input:"$Pages.PageMembers",as:"temp",cond:{$in:["$$temp.MemberId",["user1"]]}}}}}])