SELECT
    *,
    (SELECT
            COUNT(lesson_id)
        FROM
            `lesson_user`
        WHERE
            `lesson_id` IN (SELECT
                    `lessons`.`id`
                FROM
                    `lessons`
                WHERE
                    `lessons`.`section_id` IN (SELECT
                            id
                        FROM
                            `sections`
                        WHERE
                            `sections`.`course_id` = `courses`.`id`))) AS completed_lessons_count,
    (SELECT
            `lesson_id`
        FROM
            `lesson_user`
        WHERE
            `lesson_id` IN (SELECT
                    `lessons`.`id`
                FROM
                    `lessons`
                WHERE
                    `lessons`.`section_id` IN (SELECT
                            id
                        FROM
                            `sections`
                        WHERE
                            `sections`.`course_id` = `courses`.`id`))
                AND `lesson_user`.`user_id` = `course_user`.`user_id`
        ORDER BY lesson_id DESC
        LIMIT 1) AS last_completed_lesson_id,
    (SELECT
            COUNT(*)
        FROM
            `lessons`
        WHERE
            `lessons`.`section_id` IN (SELECT
                    id
                FROM
                    `sections`
                WHERE
                    `sections`.`course_id` = `courses`.`id`)) AS `lessons_count`,
    `course_user`.`user_id` AS `pivot_user_id`,
    `course_user`.`course_id` AS `pivot_course_id`
FROM
    `courses`
        INNER JOIN
    `course_user` ON `courses`.`id` = `course_user`.`course_id`
WHERE
    `course_user`.`user_id` = 1