在wordpress中如何将用户名和id存储在特定表中

global $wpdb;
$table_name = $wpdb->prefix . 'custom_users';

$sql = "CREATE TABLE IF NOT EXISTS $table_name (
    id INT(11) NOT NULL AUTO_INCREMENT,
    username VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
) $charset_collate;";

require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
dbDelta( $sql );

global $wpdb;
$table_name = $wpdb->prefix . 'custom_users';

$username = 'example_username'; // 替换为实际的用户名
$user_id = get_current_user_id(); // 获取当前用户的ID

$wpdb->insert(
    $table_name,
    array(
        'username' => $username,
        'id' => $user_id
    )
);

global $wpdb;
$table_name = $wpdb->prefix . 'custom_users';

$results = $wpdb->get_results( "SELECT username, id FROM $table_name" );

foreach ( $results as $result ) {
    $username = $result->username;
    $user_id = $result->id;

    // 进行相应的操作，如输出用户名和ID
    echo "Username: $username, ID: $user_id";
}