wpdb get_results() returns only 2 rows

You can try below query

SELECT (
    SELECT count(*) 
    FROM wp_users as temp 
    WHERE DATE(temp.user_registered) = DATE(wp_users.user_registered)
    ) as counter, 
wp_users.*
FROM wp_users

Related Posts:

  1. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  2. Return only Count from a wp_query request?
  3. Export wordpress table to excel
  4. How to make an activities stream mixing posts and comments?
  5. WP_Query Performance Issues with meta_query
  6. Should close $wpdb via $wpdb->close()
  7. Get the post permalink within the loop but without additional DB query
  8. Order by custom table and multiplication
  9. How to correctly pass values to wpdb->prepare()?
  10. Custom Query num_rows returns wrong amount
  11. Iterating through $wpdb query without using get_results for large query results
  12. wp_Qwery works to slow
  13. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  14. How to access custom WordPress database tables
  15. Is it possible to query from external database? [duplicate]
  16. WordPress query posts with multiple post_meta data
  17. List of ways to access WordPress database?
  18. Specify strict ‘order by’ in WordPress query
  19. How to set up hierarchical relationships without using plugins / meta query
  20. Does WordPress have something like Drupal’s DB API?
  21. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  22. Any way to use FETCH_KEY_PAIR with $wpdb?
  23. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  24. How to get meta key list efficiently?
  25. How to get user avatar via WPDB
  26. Include post_status check within $wpdb query
  27. WP_Query always returning the last custom post
  28. Optimising amount of calls to custom fields
  29. How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
  30. how to use transient method?
  31. order by numeric value for meta value
  32. WP_Comment_Query pagination, delving into the unknown
  33. Sort posts by category name and title
  34. Add indexing to meta_value in wp_postmeta
  35. Query causing load because of SQL_CALC_FOUND_ROWS post counting?
  36. What is an efficient way to query based on post_meta?
  37. Highlighting Sub topic in a post?
  38. how to retrieve specific product attribute value in an sql query?
  39. WordPress custom archive page
  40. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  41. Retrieve or Query Pages by ID
  42. Retrieve featured image (thumbnail) url from multiple posts with one query
  43. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  44. Get the Plugin Which Triggered a MySql Query in WordPress?
  45. How to do a query on custom taxonomies that is uncategorised?
  46. Empty tax_query array returns an empty array
  47. How do I search inside specific taxonomies in WordPress
  48. if/else on custom query gives 200 OK when condition not met?
  49. What’s the purpose / logic of split_the_query in WP_Query->get_posts
  50. Setting get_queried_object
  51. remove query arg from url after set query
  52. difference between like ‘%%%var%%’ and ‘%var%’
  53. Create WP_Query to search for posts by their categories or their parent/child categories
  54. Sort query by author: 1 author, then others
  55. Overwrite YoastSEO meta-tags with another page’s [closed]
  56. How to orderby multiple meta fields if some fields are empty
  57. Filtering posts from different categories into different section by doing WP_Query only once
  58. How to duplicate 5 posts out of WP_Query results?
  59. WP_query sorting can’t sort danish letters (æ, ø, å)
  60. Slow queries on a huge database
  61. Multisite pagination issue by multi query archive 404
  62. Query with relation and one without relation using multiple taxonomies?
  63. How Can I Put Meta_Compare in the Database-Query?
  64. plugin code is pulling information from database in one instance and not in other. What is wrong?
  65. Query only the posts with a post format of “audio”
  66. pre_get_posts – Trying to get property of non-object warning
  67. Custom WordPress Table wpdb
  68. get_post() is not returning correct value
  69. Update query for wp_posts and wp_postmeta
  70. WP_Query with page_ids in arguments without a result
  71. Insert images into wordpress post with a query
  72. WP_Query meta compare must include ALL array values
  73. Passing a SQL query to the WP Query
  74. How to insert a value to decimal type field using wpdb->prepare?
  75. Why last row deleted when refresh page
  76. pre_user_query vs pre_get_posts
  77. How to get inserted row IDs for bulk/batch insert with wpdb query?
  78. Query a database based on form input then output to another page [closed]
  79. Adding nofollow to all the post links in get_posts with pre_get_posts or WP_Query
  80. Meta query orderby meta_value_num sorting by role first
  81. How to extend WP_query to a specific table?
  82. Add to search posts query array with post IDS which will appear first
  83. How to show terms from another taxonomy
  84. My entry results are not consistently alphabetized
  85. Ignoring ‘a’ when sorting posts
  86. Custom query for tag and custom tag from 2 post type
  87. Query posts in current category but not attachment format
  88. wp_query – Modify $query to include duplicate content
  89. Optimising specific Query with ACF meta objects
  90. How to get several fields from wp_query?
  91. Slow getting posts from category
  92. Pagination not working with WP_Query (creates links but no page)
  93. Query custom post type by date field only working when two posts match the query
  94. Divide WP_Query posts by date & post type
  95. Query Posts by date range with fixed beginning and end
  96. query by meta value then date and not empty meta value
  97. New WordPress WP Query using posts from certain categories
  98. SQL query into to WP query
  99. Search results stuck on page 1
  100. Use value from meta key array for use in WP_Query