How to get an array of users with the number of articles each has?

Question

PHP

Now I do this:

// Массив всех пользователей
    $users = get_users( array(
      'meta_key'	=> '_cms_user_rating',
      'orderby'		=> 'meta_value_num',
      'order'		=> 'DESC',
    ) );
    // Количество записей для каждого пользователя
    $counts = count_many_users_posts(array_map(function($u){return $u->ID;}, $users));

Is there any way to get all users sorted by a custom field and immediately get the number of records each user has?

Answer 1

Getting a list of users is not a problem. Where is the article itself located and how is it determined who the author of the article is?
So you need a SQL query, or ready-made code???

Answer 2

Didn't check:

select 
u.id,
u.user_login,
p.count_posts  
from wp_users u  
inner join 
(
    select  
    post_author, 
    count(*) as count_posts  
    from wp_posts
    where post_type = 'post'
    group by post_author  
) p on p.post_author = u.id
order by u.id,
p.count_posts