mypmpro-export-mmpu-users.sql

/**
 * This query will retrieve all active memberships for users including MMPU orders
 * You'll need to change the wp_ database prefix on lines 21 - 24 to match your database prefix.
 */
SELECT
	DISTINCT u.ID,
	u.user_login,
	u.user_email,				
	u.user_login,
	u.user_nicename,
	u.user_url,
	u.user_registered,
	u.user_status,
	u.display_name,
	mu.membership_id,
	mu.initial_payment,
	mu.billing_amount,
	mu.cycle_period,				
	m.name as membership
FROM wp_users u
LEFT JOIN wp_usermeta um ON u.ID = um.user_id
LEFT JOIN wp_pmpro_memberships_users mu ON u.ID = mu.user_id
LEFT JOIN wp_pmpro_membership_levels m ON mu.membership_id = m.id
LEFT JOIN wp_pmpro_membership_orders mo ON mo.membership_id = m.id
WHERE mu.membership_id > 0 AND mo.status = 'success'