id  |  id_course  |  lesson_title
    1  |          3       |      Урок 1
    2  |          3       |      Урок 2
    3  |          3       |      Урок 3
    4  |          4       |      Урок 4
    5  |          4       |      Урок 5

id  |  id_lesson  |             email                |    date
  43  |          1       |     123@gmail.com      |    2018-07-09 13:17:05
  44  |          2       |     123@gmail.com      |    2018-07-09 13:18:05
  45  |          3       |     123@gmail.com      |    2018-07-09 13:19:05

$query = "SELECT h.* FROM history h LEFT JOIN lesson l ON h.id_lesson = l.id WHERE l.id_course= '$id'";