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. Filtering a function’ output for a new continued function
  7. Get html data with javascript to php array and store to wordpress database
  8. How do I create a numbered list with PHP? [closed]
  9. 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?
  10. Countdown to date function?
  11. How to use array in function to get only value I want
  12. Error while setting role
  13. Get categories names as an array to use it in theme settings
  14. How to get the last category name of a child category?
  15. How to say if meta_value is greater than 0 in an array?
  16. Getting users with a specific meta data and then querying their posts?
  17. How to use two meta_compare in an array?
  18. How to update and save user metadata on page visits?
  19. Warning: in_array() null given in PHP function
  20. Foreach loop inside an array_merge
  21. Login redirect. Check user meta and redirect accordingly
  22. Loop over Array and get the distinct ids
  23. How to access or parse key/values that have “string”
  24. User Meta Value not echoing despite Var_Dump Showing correct string
  25. Remove empty terms from array, sort alphabetically, update back to repeating field
  26. WordPress loop by meta key that is an array? and how loop multiple arrays
  27. Only show first image in foreach loop
  28. Shortcode for Listing Users from Meta Value?
  29. Conditional multidimensional arrays and array_map
  30. Getting different user data depending on where I use variable
  31. How can I get all values from my array in a loop in php? [closed]
  32. Getting posts to exclude from array
  33. Get all posts as an array ID => Name
  34. Adding Author Box Meta Links with Co-Authors
  35. I’m unable to call img path using single quotes in an array?
  36. Filter by field with array value in ACF on WP REST API
  37. Get the users that my following users are following
  38. extract serialized array to use for wp-query
  39. get users search not working with array
  40. Get the id of all images in a post
  41. Output category list inside array
  42. how to make an array of post id’s in is_single
  43. How can I split my query result in 2 arrays?
  44. Multidimensional Array
  45. Separate array output into a
  46. array_rand not working correctly?
  47. Get css class of menu item in custom menu structure
  48. Dynamically adding filters
  49. Order a WP_Query by meta value where the value is an array
  50. Edit Account – read and write to MySQL
  51. Only load certain artists on this page
  52. add the value of a variable returned in a while loop [closed]
  53. Update value of a associative array with update_post_meta
  54. How to make sure relative URL works when site is not on root domain?
  55. Get URI from PodPress using PHP
  56. How To Pass Array To get_the_category_by_ID() and Get An Array Back?
  57. using images in next/previous_post_link [closed]
  58. Finding and removing duplicates within WP Arrays
  59. Using multiple variables to assign categories to an array
  60. Uses for function: wp_update_user
  61. Custom functions for string data calculations
  62. Add custom fields from different posts
  63. Update user repeater meta (ACF) with another user meta field value
  64. Create condition for Author bio Social Links
  65. Repeat a function with 24hrs gap for n number of days
  66. MySQL Query Returns Array () In Shortcode
  67. How to store checkbox data for individual users?
  68. Problem with inserting multiple images in gallery of each WooCommerce product programmatically
  69. Convert a column of a table containing an Array as response in HTML
  70. How do I Populate a Table Field with User Meta Data?
  71. Sending simple variable on single page to WP JSON
  72. Create an array with all the links of the years’ archive (of a custom post type)
  73. Display just one post from a loop of 5 posts?
  74. Order users by random not working?
  75. Redux option doensn’t seem when include from functions.php
  76. How to add and subtract user meta values after post meta update
  77. in_array not working on dev server but works on localhost
  78. User meta needed in query is serialized – how to unserialize safely?
  79. Include User ID in iFrame URL
  80. WP custom posts: filter results to custom taxonomy tag that corresponds to user meta field
  81. Usermeta data unserialize, extract and display in table in WordPress
  82. 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?
  83. how to separate an array into different arrays and save them into db?
  84. Change user metadata on registration (show_admin_bar_front = false)
  85. How to insert multiple rows and columns in database using array
  86. Display one random image from Media Library
  87. How to display MySQL table data which is stored as an array?
  88. Store data from JavaScript object to custom table in user account
  89. ACF – Get ID of relationship field in flexible content
  90. Export WordPress User Meta to CSV/Excel
  91. Updating User Profile information removes image
  92. Replace an array (with identical values) with another array in the_content
  93. How to change the value of a variable using input field?
  94. Display current user metadata on WordPress page
  95. Show the subcategory name based on current product
  96. How Can I Display the Last Modified Date for User Profiles on WordPress?
  97. Get user by meta data key and velue
  98. How to filter specific element of an array in wordpress/php?
  99. Where do I implement this display of User Meta Data, and how to put it in a table?
  100. WP post meta – for loop inside for loop
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)