Mysql multi-subquery creation of multiple LEFTJOIN views

Create view 'v _ noprovide 'as select * FROMtb_sectionWHEREprovide = '0' create view 'v _ thismonth' AS SELECTts. userId AS id, CONCAT ('thismonth: ', SUM (ts. amount), 'yuanyuan ') AS 'thismonth' FROMtb _ section AS tsWHEREts. yearMonth = DATE_FORMAT (NOW (), '% Y % m') create view 'v _ lastmonth' AS SELECTts. userId AS id, CONCAT ('lastmonth: ', SUM (ts. amount), 'yuanyuan ') AS 'lastmonth' FROMtb _ section AS tsWHEREts. yearMonth = DATE_FORMAT (DATE_SUB (NOW (), INTERVAL 1 MONTH), '% Y % m') create view 'v _ usermanage' ASSELECTu. id AS id, u. email AS email, u. 'name' AS 'name', CONCAT (COALESCE (la. lastmonth, 'lastmonth: 0yuan '), COALESCE (th. thismonth, 'thismonth: 0yuan ') AS recent, Sum (COALESCE (B. amount, 0) AS totalBonus, Sum (COALESCE (n. amount, 0) AS unbilledFROMtb_user AS uLEFT JOIN tb_bonus AS B ON u. id = B. receiverIdLEFT JOIN v_noprovide AS n ON u. id = n. userIdLEFT JOIN v_thismonth AS th ON u. id = th. idLEFT JOIN v_lastmonth AS la ON u. id = la. idGROUP BY u. id