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. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  14. How to pass orderby params to $wpdb->prepare()?
  15. how update data through ajax and jquery
  16. Debugging wp_query orderby for taxonomy
  17. Is it possible to query from external database? [duplicate]
  18. How can I prevent certain custom roles from seeing other custom roles on the user list page?
  19. Meta Query doesn’t works as espected
  20. Include post content of linked posts in search
  21. Prevent author bio page from showing in search results
  22. Make a SQL query with wpdb in WordPress
  23. Get multiple users with meta value in one query and populate WP_User class
  24. Getting additional columns from sql
  25. List of ways to access WordPress database?
  26. Reduce number of SQL queries inside WP_Query loop to fetch author data
  27. Display if author page is author page of current user
  28. how to get Nearby zipcode
  29. Getting rid of unwanted nonSQL syntax characters when debugging a query
  30. Get user first name from custom endpoint
  31. Query where ANDing slug values not working
  32. Update query for wp_posts and wp_postmeta
  33. Show menus to one admin username
  34. Slow Query On Search
  35. WP_Query: apply an SQL function to meta fileld value
  36. mysql query order by
  37. Storing an array of objects related to each user
  38. Create one-use post dynamically, add to main query, do not insert post (user profile view)
  39. Link Author URL’s based on a custom field
  40. WP_Query with page_ids in arguments without a result
  41. How to avoid filling up an array each time I run a WP_query?
  42. How to SQL query posts IDs by categories AND authors?
  43. Randomly select one of last 3 posts
  44. Query multiple meta key values for template
  45. Query to get last posts from authors of blog
  46. get_var is neither a string, integer, or array …?
  47. Passing a SQL query to the WP Query
  48. Query pages created by deleted users
  49. WP_Query() not working as expected
  50. Query posts by post type, author and post meta
  51. Random users always showing same 8 users
  52. Why last row deleted when refresh page
  53. Woocommerce Get Orders By Meta Value
  54. SQL to join u3g_users & u3g_meta_value with repeating data
  55. Any way to use FETCH_KEY_PAIR with $wpdb?
  56. What is the equivalent WP_Query of a SQL Query?
  57. INNER JOIN custom tables – SQL Query
  58. Meta query orderby meta_value_num sorting by role first
  59. use mysql variable in a $wpdb->query to reindex a column?
  60. One of two similar WP Query is very slow
  61. Fix wp_term_relationships slow query in get_posts
  62. Translating WP query into to SQL query
  63. WordPress Query optimaization for slow query
  64. Sorting query_posts() with a complex orderby filter
  65. Case insensitive ORDERBY in wpquery
  66. Pre_get_posts only show posts by administrator roles
  67. How to query 5 users in random who have published more than 10 posts
  68. How to query users by post count no less than 10
  69. Merge wp-query and get_users
  70. Filtering posts for unique titles, only the most recent
  71. Query postmeta based on meta_value, return array of post_id
  72. WP_Query: Query posts only if their access is restricted to logged user’s role
  73. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  74. How to search CPTs in draft using get_page_by_title()
  75. Get all wp_users sort by metakey
  76. Order Posts By Custom Field That is an array of objects
  77. Logging search queries for logged-in users
  78. Multiple wpostmeta.meta_key
  79. Calculating efficiently on large amount of data generated by wp_query
  80. List users by Year of Birth using a foreach loop to dynamically populate years and data
  81. Slow query when selecting with large meta query or post__in
  82. SQL Query Search page
  83. What argument does my function need to echo get_results() query results
  84. Show subscriber id in loop
  85. Include post_status check within $wpdb query
  86. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  87. Custom post order when using OR relation
  88. WP_Query always returning the last custom post
  89. WP Query to order posts by multiple meta fields
  90. How to connect database table to each registered wordpress user.
  91. Get a list of the last posts grouped by author and filtered by category
  92. How to count post meta key values for all posts in database
  93. Custom WP_Query with SQL directives for getting posts by authors and terms
  94. meta_query dates from an array
  95. How to return value from sql and display it
  96. orderby in WP_query doesn’t works
  97. WP_Query with several meta_query-statements and order by meta_value
  98. Displaying content to search engines but via navigation only for registered users.
  99. Query Users by post count, last 30 days and display each users post count according to post type
  100. Different sql queries count indicator on the main page [closed]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)