<?php

global $wpdb;

$user_ids = $wpdb->get_col( "SELECT ID FROM $wpdb->users LIMIT 20" );

$progress = WP_CLI\Utils\make_progress_bar( 'Saving initial email address for existing users', count( $user_ids ) );

foreach ( $user_ids as $user_id ) {
	$progress->tick();

	$user = get_user_by( 'ID', $user_id );
	if ( ! $user ) {
		continue;
	}

	$signup = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->signups} WHERE user_login = %s", $user->user_login ) );
	if ( ! $signup ) {
		WP_CLI::log( "No signup record found for user ID {$user_id} ({$user->user_login}), skipping." );
		continue;
	}

	update_user_meta( $user_id, 'cac_initial_email_address', $signup->user_email );

	WP_CLI::log( "Saved initial email address for user ID {$user_id}: {$signup->user_email}" );
};

$progress->finish();