Get all the related data from WordPress DB

Your problem is the constants OBJECT_K.

In the documentation you can read that this constant ensures that duplicate keys are discarded.

From the wordpress codex entry:

Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants. With one of the first three, return an array of rows indexed from 0 by SQL result row number. Each row is an associative array (column => value, …), a numerically indexed array (0 => value, …), or an object. ( ->column = value ), respectively. With OBJECT_K, return an associative array of row objects keyed by the value of each row’s first column’s value. Duplicate keys are discarded.

WordPress codex: get_results

Related Posts:

  1. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  2. Help With MySQL to WPDB Query Conversion
  3. Creating mySQL procedure with $wpdb
  4. What are the common security flaws I need to look for? [closed]
  5. Making my plugin multi-site compatible
  6. dbDelta only creates the last table
  7. Creating 20,000 Posts or Pages using a .csv file?
  8. How does WordPress handle MySQL row lock errors?
  9. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  10. Plugin Development sqlite or WordPress’ database
  11. Correct way to perform non-cacheable DB query
  12. Problem with creating tables for Plugin
  13. Prevent duplicate records in plugin table
  14. Change commission_status paid when withdraw_status vendor is completed
  15. How do I run SQL queries on a WordPress web page? [closed]
  16. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  17. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  18. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  19. Insert data from .sql file in wordpress plugin
  20. WordPress Backend HA (Automatic failover)
  21. Migrating to WordPress Recipe Plugin and Some SQL Issues
  22. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  23. Speeding SQL queries for a large database?
  24. Cannot get wpdb data (Error in a simple fuction) [closed]
  25. WPDB: Update table
  26. Issue running db create table query from static method
  27. $wpdb update query in plugin only updating one column
  28. DB Query not working in Plugin
  29. Way to send multiple values for column to MySQL?
  30. WordPress plugin: efficient way to store large data
  31. Displaying data from another database
  32. Plugin generating unexpected output – on WP mysql dump import
  33. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  34. Can’t create tables with my plugin
  35. Integrating Custom Database with WordPress
  36. How to display results from a data table with an encrypted user id?
  37. JOIN and SUM different statement results (Mailster Database)
  38. How to get the custom field value using SQL query
  39. Memcaching recurring SQL Queries
  40. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  41. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  42. How to get database connection details without longing to cpanel in WordPress?
  43. Performing CRUD operations on front end in wordpress
  44. Display a number value from mysql query in WP
  45. How to securely controlling data without keeping it in postmeta?
  46. WordPress UPDATE queries on MySQL database stuck
  47. Using id to show item
  48. Resetting AUTO_INCREMENT primary key
  49. Re-writing MySQl query for execute faster
  50. Create Database Tables on Plugin Activation hook
  51. Create Array from data in the OPTIONS table
  52. Write mysql credentials in plugin
  53. Linking Plugin Files to WP
  54. how to search through plugin in wordpress cimy-user-extra-fields?
  55. How to display blog posts only authored by the administrator
  56. How to dispaly post informations (such as titles) in an admin plugin menu page?
  57. How can I delete the options from DB when the plugin is deleted?
  58. How to check record is exist or not in WordPress CRUD Operation with $wpdb
  59. Redesigning Custom Post Type “Add New” page
  60. Is there any record of installed plugins in the database?
  61. Custom headers for the WordPress plugin directory
  62. plugin wants to update to wrong plugin
  63. How can I add a custom header to a custom template in a plugin without using the theme folders
  64. Trying to avoid including wp-load.php
  65. Stackoverflow type of badge plugin giving warnings in WordPress 3.5
  66. AJAX Call Via Vanilla JavaScript In WordPress Plugin Development
  67. Custom values are not translated
  68. Make the plugin directory recognize new version numbers
  69. How to create popup same as wordpress popup feature
  70. How to make first_name and last_name required fields in user profile?
  71. Avoiding Duplicate function names in Post Loop (WP_Footer script)
  72. Can we use a webservice with WordPress?
  73. WooCommerce get_price returning wrong price when used via ajax
  74. New User Form – Custom Menu Page
  75. Checking instances of scripts in wp_head
  76. How can I prevent my plugin go development trunk [closed]
  77. Are functions in main plugin file called before function bound to register_activation_hook runs?
  78. How to create a code editor for my plugin .?
  79. Manually set a custom admin sub-menu selected?
  80. WordPress SQL Issue not returning correct reselts
  81. How to make custom plugin run on demand?
  82. WooCommerce – set session with new cart item meta when updating cart item quantity [closed]
  83. Using WordPress to build membership Page
  84. Set WordPress Transient Expiration via Variable Value
  85. Override plugin class which has namespace
  86. Quick press publish post hook
  87. I cannot include a file in my plugin settings page
  88. force logged in user to stay in the dashboard
  89. Clicking custom plugin admin menu redirects to “No Update Required” on live site
  90. The plugin generated 227 characters of unexpected output during activation. If you notice “headers already sent” messages
  91. 500 Internal server error wp_handle_upload_prefilter
  92. Installation failed, trying to install ANY plugin
  93. WordPress the_content Filter and GET Parameter
  94. Help Code Review – I need to write on .htaccess file from theme’s function.php
  95. Need to hide an element depending on date and post category
  96. How to add a handler for a button in plugin?
  97. Using Taxonomies with Vote It Up plugin chart [closed]
  98. wordpress last all added get meta value by post id
  99. Jquery post responses 500 error after some time and lastly an 503 error
  100. How to provide page_template path in custom plugin using WordPress