wp_update_user_counts

WordPress Version: 6.1

/**
 * Updates the total count of users on the site.
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 * @since 6.0.0
 *
 * @param int|null $network_id ID of the network. Defaults to the current network.
 * @return bool Whether the update was successful.
 */
function wp_update_user_counts($network_id = null)
{
    global $wpdb;
    if (!is_multisite() && null !== $network_id) {
        _doing_it_wrong(__FUNCTION__, sprintf(
            /* translators: %s: $network_id */
            __('Unable to pass %s if not using multisite.'),
            '<code>$network_id</code>'
        ), '6.0.0');
    }
    $query = "SELECT COUNT(ID) as c FROM {$wpdb->users}";
    if (is_multisite()) {
        $query .= " WHERE spam = '0' AND deleted = '0'";
    }
    $count = $wpdb->get_var($query);
    return update_network_option($network_id, 'user_count', $count);
}