Code Samples: Select Specific User with a User Role

$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

$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/