get_users when from meta key that has serialized values

I’m assuming that the meta_value has a serialized array, not the meta_key (For it would make no sense to have the meta_key to be a serialized array)

You really should save the values in seperate fields to be able to query it by wordpress internal functions like get_users.

If you definitely have to preserve this data-structure, you have to go by directly accessing the Database by wpdb like this:

global $wpdb;
$claimed_user_ids = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT user_id FROM $wpdb->usermeta WHERE meta_key = %s AND meta_value LIKE %s",'<META_KEY>','%username%'));

(replace with the meta_key which holds the serialized array).

Happy Coding, Kuchenundkakao

Related Posts:

  1. If Array Values Match Another Array’s Values, Then
  2. Comapare get_user_meta value
  3. How can get all users by current user meta?
  4. Store custom field’s multiple values in one user meta key
  5. How can get all users by current user meta (array)?
  6. Sorting list of sites from multisite network using wp_get_sites
  7. How to store the_title() into a variable to reutrn the value, not just echo it
  8. How to update single value in multi dimensional Post Meta?
  9. Looping through WP_Post Object
  10. Using a javascript file to access a get posts array
  11. Generate an array of parent/child page IDs, based on parent page name
  12. How do I output a database option that is an array into a get_posts array?
  13. How do I dynamically generate args for wp_query?
  14. Parsing php string in jquery [closed]
  15. Working with query_posts ( arrays and query strings)
  16. How do I display a user’s previous orders as a select box option on a product?
  17. How to properly loop through these external URLs to get them into the sitemap using this hook
  18. Recent posts with featured image or fallback image with permalink
  19. Call global variable array() in woocommerce child/template
  20. Storing Array from returned database query and using the array in a new query
  21. How to use an associative array in post__in with WP_Query?
  22. Populate dropdown with Child Pages based on Parent Page chosen
  23. function to assign user role based on a field from usermeta
  24. How can I save unique user data on my site? [closed]
  25. PHP Array Returning [object Object]. Tried existing answers results with no luck
  26. Exclude posts based on meta value
  27. Alter required message using comment form api
  28. a:0:{} is replaced into database as s:6:”a:0:{}”;
  29. Advanced Custom Fields – display label and value only if value entered
  30. wp_force_remove_style’ not found
  31. How can I access string value in an array?
  32. How to use if statement in an array? [closed]
  33. How to array only one key from another array
  34. Filtering a function’ output for a new continued function
  35. Why is an array created in a function hooked to customize register populated when customizer is loaded but not when the front-end is loaded?
  36. Countdown to date function?
  37. Get categories names as an array to use it in theme settings
  38. How to get the last category name of a child category?
  39. How to update and save user metadata on page visits?
  40. Foreach loop inside an array_merge
  41. User Meta Value not echoing despite Var_Dump Showing correct string
  42. WordPress loop by meta key that is an array? and how loop multiple arrays
  43. Getting different user data depending on where I use variable
  44. Getting posts to exclude from array
  45. I’m unable to call img path using single quotes in an array?
  46. Get the id of all images in a post
  47. Output category list inside array
  48. how to make an array of post id’s in is_single
  49. array_rand not working correctly?
  50. Get css class of menu item in custom menu structure
  51. Dynamically adding filters
  52. Edit Account – read and write to MySQL
  53. How To Pass Array To get_the_category_by_ID() and Get An Array Back?
  54. Add custom fields from different posts
  55. Sending simple variable on single page to WP JSON
  56. Order users by random not working?
  57. in_array not working on dev server but works on localhost
  58. Include User ID in iFrame URL
  59. How can I show how much water got saved on this order (making use of the number of items bought) on a thank-you-page?
  60. How to display MySQL table data which is stored as an array?
  61. Store data from JavaScript object to custom table in user account
  62. Updating User Profile information removes image
  63. How to change the value of a variable using input field?
  64. Show the subcategory name based on current product
  65. How to filter specific element of an array in wordpress/php?
  66. Where do I implement this display of User Meta Data, and how to put it in a table?
  67. Notice : Array to string conversion on array_intersect user meta
  68. Get field in readable word
  69. Remove item from post_meta array via AJAX
  70. Make sticky post with FacetWP
  71. Fatal error when using array_diff() function inside of wp_update_nav_menu hook?
  72. PHP array to jQuery array ” Uncaught SyntaxError: Unexpected token < "
  73. Adding user meta to post meta wp_insert_post() not working
  74. Get meta_query value by user meta array
  75. Display posts using post ID’s in an array
  76. How can i iterate through this shortcode array?
  77. Display a single row from nested array of custom field data
  78. Private messaging – Getting and displaying the avatar/url of a message recipient
  79. Updating custom user meta
  80. Updating meta_value in a custom key
  81. Reformat data within a nested array
  82. How to find the function which is outputting Array
  83. Create Customization Controls from Array
  84. Limit the number of successful logins
  85. Non-array argument in array_merge()-function [closed]
  86. Get author meta of all writers
  87. Let users register weight each day and save it in DB
  88. !in_array doesnt recognize category
  89. Showing all post from all post type in admin backstage
  90. How to set if meta_value is lower < than other meta_value in a get_posts array?
  91. Populate checkboxes from array
  92. Use php array outside his function
  93. PHP Use Declared array Variable inside already Declared Array
  94. A better way to write this php function
  95. Why is my array_diff usage breaking things?
  96. Grabbing value of input field inside of array
  97. save array of objects with update_option
  98. Custom WordPress Function – Adding items from Foreach Loop into an array and Updating Field based on array of IDs (ACF + WooCommerce)
  99. How to initialise WP_Query on the basis of a specific meta_value and continue iterating rest?
  100. PHP – Converting elements to actual values