Hi @NoahCameron, welcome to the forum! 
We should be able to achieve this with a JS Query. Create this filter manually with JS.
For example, using a "Multiselect" component, here is the implementation for this logic:
Multiselect with the options:
SQL query that gets all users and formats the output to an array:
JS Query that filters according to what is selected on the Multiselect component:
Note: In the if statement, as long as the role property of an element (status in your case) is included in the selected options, we collect the element.
Additional logic to show all users when no options are selected:
Now our filtering is works as expected:
Let us know if you have any questions! 