Creating a view for wp_usermeta to return data as one row

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `active_users_view`
AS SELECT
   `u1`.`ID` AS `ID`,
   `u1`.`user_login` AS `user_login`,
   `u1`.`display_name` AS `display_name`,
   `m1`.`meta_value` AS `email_enable`,
   `m2`.`meta_value` AS `expired`,
   `m3`.`meta_value` AS `user_cron_job`,
   `m5`.`meta_value` AS `_save_notification`
FROM (((((`wp_users` `u1` join `wp_usermeta` `m1` on(((`m1`.`user_id` = `u1`.`ID`) and (`m1`.`meta_key` = '_email_enable')))) join `wp_usermeta` `m2` on(((`m2`.`user_id` = `u1`.`ID`) and (`m2`.`meta_key` = 'expired')))) join `wp_usermeta` `m3` on(((`m3`.`user_id` = `u1`.`ID`) and (`m3`.`meta_key` = 'user_cron_job')))) join `wp_usermeta` `m4` on(((`m4`.`user_id` = `u1`.`ID`) and (`m4`.`meta_key` = 'wp_capabilities')))) join `wp_usermeta` `m5` on(((`m5`.`user_id` = `u1`.`ID`) and (`m5`.`meta_key` = '_save_notification')))) where ((`m4`.`meta_value` like '%customer%') and (`m1`.`meta_value` = '1') and (`m2`.`meta_value` > unix_timestamp(now())));