select d.date, c.title 
from course_date d 
left join course c on d.courseID = c.id 
left join course_user u on c.id = u.courseID 
where userID = 1;