$x = pods('user')->find(
[
'select' => " <code>t</code>.*, <code>usermeta</code>.* ",
'join' => " LEFT JOIN <code>wp_usermeta</code> as <code>usermeta</code> ON <code>usermeta</code>.<code>meta_key</code> = 'wp_capabilities' AND <code>usermeta</code>.<code>user_id</code> = <code>t</code>.<code>ID</code>",
'where' => " ( ( <code>usermeta</code>.<code>meta_value</code> LIKE '%administrator%' ) ) ",
'orderby' => ' <code>t</code>.<code>display_name</code>, <code>t</code>.<code>ID</code> '
]
);
var_dump($x->data() ); // returns all users with role administrator
Contributed by https://wordpress.org/support/topic/include-working-solution-select-user-with-a-specific-role/
