title: Wordpress: Get list of users ordered by post count
body: <p>I am trying to come up with a function that will output a list of usernames in wp_users ordered by their post count. Right now I am able to get all users, and I am able to get post counts for individual users, but I am having a difficult time combining those two sets of data. any help would be greatly appreciated!</p>
  
  <p>I'm thinking I will need something that combines these two queries:</p>
  
  <pre><code>SELECT COUNT(*) FROM $wpdb-&gt;posts WHERE post_status = 'publish' AND post_author = $auth
  
  SELECT user_nicename FROM $wpdb-&gt;users
  </code></pre>