EE3: Filtering models with "in (select"

Hi, I have to create a Member having a email address in an additional table/Model Person.

Now I want to filter all Person with an email address not in Member with something like

Person->filter('email', 'NOT IN', '(select email from exp_member)')

I know this doesn’t work, but is there an alternative way? I can’t do it with a loop there are to much records.

Do I really have to build an array of email addresses for all 5000 members to commit it to the filter?

Thanks

Matthias