This new method should work. It looks at all the capability values to find “subscriber”, and hides it.
Try this query
$wpdb->get_results(
"SELECT display_name
FROM $wpdb->users WHERE 1=1 AND {$wpdb->users}.ID IN (
SELECT {$wpdb->usermeta}.user_id FROM $wpdb->usermeta
WHERE {$wpdb->usermeta}.meta_key = '{$wpdb->prefix}capabilities'
AND {$wpdb->usermeta}.meta_value NOT LIKE '%subscriber%') ORDER BY display_name ASC"
);