SQL User Query by Multiple Roles using PHP

Taking @Kaperto’s advice, I did the following which works:

$user_query = new WP_User_Query( array(
    'role__in'    => ['role1','role2''],
    'orderby' => 'meta_value_num',
    'order' => 'ASC',
) );   
$users = $user_query->get_results();

Related Posts:

  1. SQL query equivalent to WP User Query
  2. WP User Query get all authors with last name starting with specific letter
  3. Sort users by “birthday” using WP_User_Query
  4. Slow WP_Query for custom post type
  5. Hide Administrators From User List except current user (administrator)
  6. How to display user order by role
  7. Order by summing multiple values
  8. How I can change the condition or compare operator for WP_Query in pre_get_posts
  9. SQL query injection with fifu image
  10. WP Query – grouping posts by same meta key, adding together values from another key
  11. Set “editor” role to existing user
  12. Get users query makes the site loading time too big?
  13. WP_Query with “post_title LIKE ‘something%'”?
  14. Pagination with custom SQL query
  15. Use REGEXP in WP_Query meta_query key
  16. Order by DESC, ASC in custom WP_Query
  17. Is it possible to wrap Geo Location search around WP_Query?
  18. Getting wrong relationship value in $args in wp_Query?
  19. Getting all user metadata from user
  20. Is it possible to select against a post’s parent’s fields with WP_Query?
  21. How to make an activities stream mixing posts and comments?
  22. Return ID of authors who have at least one post
  23. SQL Statement generated by WP_Query not producing expected results
  24. What is an efficient way to query based on post_meta?
  25. What’s wrong with this WP query?
  26. Group posts by meta_key
  27. Recommended way to drop a pending query (in pre_get_posts)?
  28. how to retrieve specific product attribute value in an sql query?
  29. Would this post meta be better added to the post table rather than post_meta table
  30. Order By Multiple Meta Fields
  31. meta_query on a date range using an array of values
  32. How to hide post content/meta from everyone except the post author and admin
  33. Filter user list that meta_value is empty
  34. Query wp_usermeta alongside wp_users
  35. Advanced WP Query hogs the SQL server
  36. WordPress Query is taking more then 20 second and stuck on creating index
  37. Get the Plugin Which Triggered a MySql Query in WordPress?
  38. Mysql query LIKE not working
  39. Select from wp_post and multiple meta_value from wp_postmeta
  40. Order by custom table and multiplication
  41. How to correctly pass values to wpdb->prepare()?
  42. Single meta_query query using OR instead of AND in request’s WHERE statement
  43. How to order posts in wp_query by the user role (2 roles in array)
  44. How to use MySQL’s MATCH AGAINST in WP_Query?
  45. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  46. Complex WP SQL Query
  47. Add “Category” to Mysql Query
  48. Mysql query and order meta value
  49. Help with WP_Query – Too many mySQL queries
  50. Using hook to use DISTINCT in a wp_query
  51. Sorting events by descending date, and ascending time if multiple events on a date
  52. pagination with ‘no_found_rows’ => true,
  53. Import wp users via one click demo option
  54. How to verify wp user password by sql query in wp? [closed]
  55. Dynamic User Id
  56. Wp query show post by author name or post title or post content
  57. Why does get_posts only show results for Admins or logged-out users?
  58. wordpress ajax relationship query
  59. WordPress SQL Issue not returning correct reselts
  60. Debugging wp_query orderby for taxonomy
  61. How can I prevent certain custom roles from seeing other custom roles on the user list page?
  62. Meta Query doesn’t works as espected
  63. Get multiple users with meta value in one query and populate WP_User class
  64. Display if author page is author page of current user
  65. Get user first name from custom endpoint
  66. Query where ANDing slug values not working
  67. Show menus to one admin username
  68. WP_Query: apply an SQL function to meta fileld value
  69. Link Author URL’s based on a custom field
  70. How to avoid filling up an array each time I run a WP_query?
  71. How to SQL query posts IDs by categories AND authors?
  72. Randomly select one of last 3 posts
  73. Query multiple meta key values for template
  74. Passing a SQL query to the WP Query
  75. WP_Query() not working as expected
  76. Query posts by post type, author and post meta
  77. Random users always showing same 8 users
  78. Any way to use FETCH_KEY_PAIR with $wpdb?
  79. What is the equivalent WP_Query of a SQL Query?
  80. INNER JOIN custom tables – SQL Query
  81. use mysql variable in a $wpdb->query to reindex a column?
  82. One of two similar WP Query is very slow
  83. Fix wp_term_relationships slow query in get_posts
  84. How to query users by post count no less than 10
  85. Query postmeta based on meta_value, return array of post_id
  86. WP_Query: Query posts only if their access is restricted to logged user’s role
  87. Multiple wpostmeta.meta_key
  88. What argument does my function need to echo get_results() query results
  89. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  90. WP Query to order posts by multiple meta fields
  91. How to connect database table to each registered wordpress user.
  92. Get a list of the last posts grouped by author and filtered by category
  93. How to return value from sql and display it
  94. WP_Query with several meta_query-statements and order by meta_value
  95. Parsing External Table Arguments
  96. wpdb LIKE request shows all database data
  97. How to add a custom field and incrementing value for all the published posts
  98. SQL query into to WP query
  99. Bulk delete comments, foreach loop
  100. How to make OR condition in WP_Query
techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduseduseduseduseduedusedusedu