如何获取woocommerce中角色为“customer”的每个用户的最后订单日期和电子邮件用户

// 获取所有角色为"customer"的用户列表
$users = get_users( array( 'role' => 'customer' ) );

// 存储用户的电子邮件地址和最后订单日期
$userData = array();

// 遍历每个用户
foreach ( $users as $user ) {
    // 获取用户的电子邮件地址
    $email = $user->user_email;

    // 获取用户的最后订单日期
    $lastOrderDate = get_last_order_date( $user->ID );

    // 存储用户数据
    $userData[] = array(
        'email' => $email,
        'last_order_date' => $lastOrderDate
    );
}

// 打印用户数据
foreach ( $userData as $data ) {
    echo 'Email: ' . $data['email'] . ', Last Order Date: ' . $data['last_order_date'] . '<br>';
}

// 获取用户的最后订单日期
function get_last_order_date( $user_id ) {
    global $wpdb;

    // 查询订单表，按照订单日期降序排序
    $query = "SELECT post_date FROM {$wpdb->prefix}posts WHERE post_type = 'shop_order' AND post_status IN ( 'wc-completed', 'wc-processing' ) AND post_author = %d ORDER BY post_date DESC LIMIT 1";
    $date = $wpdb->get_var( $wpdb->prepare( $query, $user_id ) );

    return $date;
}