chirag query

SELECT u.id, 
       u.user_login,
       u.user_email,
       u.user_registered, 
       MAX(IF(m.meta_key = 'first_name',m.meta_value,null)) AS firstName, 
       MAX(IF(m.meta_key = 'last_name',m.meta_value,null)) AS lastName,
       MAX(IF(m.meta_key = 'free_trial',m.meta_value,null)) AS freeTrialEnddate,
       MAX(IF(m.meta_key = 'membership_plan',m.meta_value,null)) AS plan,
       MAX(IF(m.meta_key = 'membership_expiration',m.meta_value,null)) AS membershipEnded,
       MAX(IF(m.meta_key = 'wp_last_active',m.meta_value,null)) AS lastLogin,
       sub.post_date,
       sub.post_status
FROM   wp_users u 
       JOIN wp_usermeta m
       ON m.user_id = u.id
       LEFT JOIN wp_postmeta as subMeta ON (subMeta.meta_value=u.id AND meta_key='_customer_user')
       LEFT JOIN wp_post as sub ON (subMeta.post_id=sub.id)
GROUP  BY u.id,
          u.user_login;