select *, null as collect_id from table1 where user_id = 527
union
select id,user_id,null as type_id,null as pro_id, collect_id from table2 where user_id = 527;

SELECT
"模塊名",
"事件編碼",
"點擊數(shù)量",
"使用時長（單位：分）"
FROM

(SELECT 
T.fun_name as "模塊名",
T.event_code as "事件編碼",
SUM(click_records) as "點擊數(shù)量"
FROM 
(SELECT m.* FROM default.daily_new_clientrpt_master m WHERE event_id in ( SELECT max(event_id) AS "事件" from default.daily_new_clientrpt_master group by user_name,fun_code ORDER BY "事件" DESC ) ) T where day = today() GROUP BY "模塊名" ,"事件編碼") T5
JOIN
(
SELECT 
T.fun_name as "模塊名",
T.event_code as "事件編碼",
round(sum(stay_time)/60000,0) as "使用時長（單位：分）"
FROM 
(SELECT m.* FROM default.daily_new_clientrpt_master m WHERE event_id in 
 ( 
 SELECT "事件" FROM (
 SELECT max(event_id) AS "事件", max(stay_time) AS "事件1" from default.daily_new_clientrpt_master group by user_name,fun_code ORDER BY "事件1" DESC) )
) 
 T where day = today() AND like(event_code,'%10000') GROUP BY "模塊名" ,"事件編碼"
) T6 ON T5."模塊名"=T6."模塊名" AND T5."事件編碼"=T6."事件編碼"