event最近的连续事件问题

mysql题目：有uid，event_time，event字段
其中event字段值分为init和read事件
求，每次用户init之后，紧邻的read事件

尝试建了个表，写了语句用于记录

select t.id,t.uid,t.event_time,t.event,a.id2 id1,a.event_time2 event_time1,a.event2 event1 from test t
left join (
		select max(t1.event_time) event_time,t2.id id2,t2.event_time event_time2,t2.event event2 
		from test t1 
		left join test t2 on t1.uid=t2.uid and t2.event=2
		where t1.event=1 and t1.event_time<=t2.event_time
		group by t2.id
) a on t.event_time = a.event_time
where t.event=1