select * from video_onelesson where video_onelesson.video_id in (
    select rentvideo_onelesson.video_id from rentvideo_onelesson where rentvideo_onelesson.member_id = (
        select member_onelesson.member_id from member_onelesson where member_onelesson.name = '色色'
    ) 
) ;

select * from member_onelesson where member_onelesson.member_id in (
	select rentvideo_onelesson.member_id from rentvideo_onelesson where rentvideo_onelesson.video_id = (
		select video_onelesson.video_id from video_onelesson where video_onelesson.title = '色即是空1' 
	)
);