Export WordPress users with meta

export-users-with-meta.sql

SELECT
  t1.ID, t1.user_email,
  MAX(CASE WHEN t2.meta_key = 'first_name' THEN meta_value END) AS first_name,
  MAX(CASE WHEN t2.meta_key = 'last_name' THEN meta_value END) AS last_name,
  MAX(CASE WHEN t2.meta_key = 'paying_customer' THEN meta_value END) AS paying_customer,
  MAX(CASE WHEN t2.meta_key = 'billing_title' THEN meta_value END) AS billing_title
FROM th_users AS t1 
INNER JOIN th_usermeta AS t2 ON t1.ID = t2.user_id
GROUP BY t1.ID, t1.user_email