我想根据他们的帖子数量显示前10位作者的列表，然后按姓氏排序。据我所知，这并不简单，因为用户的姓氏驻留在用户元表中。

我已经成功地编写了代码，以实现我所寻找的，请参阅下面的代码。然而，我想知道是否有可能优化这段代码，使其使用更少的db查询。有人有什么建议吗？

        <?php /* 1. Get list of 10 users with the most posts, sorted by post count. */ ?>
        <?php $blogusers = get_users(\'exclude=1,2&order=DESC&orderby=post_count&number=10\'); ?>

        <?php /* 2. Set up array with author ID\'s and user last names from the user meta table */ ?>
        <?php foreach($blogusers as $t){
            $user_info = get_userdata($t->ID);

            // Sanitises connecting words in last names to enable proper sorting
            $lastname = $user_info->user_lastname;
            $patterns = array();
            $patterns[0] = \'/van /\';
            $patterns[1] = \'/het /\';
            $patterns[2] = \'/de /\';
            $patterns[3] = \'/der /\';
            $patterns[4] = \'/\\\'t /\';
            $replacements = array();
            $replacements[0] = \'\';
            $replacements[1] = \'\';
            $replacements[2] = \'\';
            $replacements[3] = \'\';
            $replacements[4] = \'\';
            $cleaned_lastname = preg_replace($patterns, $replacements, $lastname);

            // Store cleaned last name with author ID key in array
            $poep[$t->ID] = $cleaned_lastname;
        } ?>

        <?php /* 4. Sort array based on last name */ ?>
        <?php asort($poep); ?>

        <?php /* 5. Display tiles */ ?>
        <?php $count =1;?>          

        <?php foreach ( $poep as $key => $val ) : ?>
        <?php $user = get_user_meta($key); ?>

        <a href="<?php echo get_author_posts_url($key); ?>" class="tile author_tile_link author_tile<?php if ($count % 5 == 0) { echo \' last\'; } ?>">
            <?php echo get_wp_user_avatar($key, \'thumbnail\'); ?>
            <div class=\'tile_content\'>
                <h2><?php echo get_the_author_meta(\'first_name\',$key).\' \'.get_the_author_meta(\'last_name\',$key); ?></h2>
                <span class="button">Zie alle artikelen</span>
            </div>
        </a>
        <?php $count++; ?>
        <?php endforeach; ?>