$courses = auth()->user()->courses()->select([
            DB::raw('*'),
            DB::raw('(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'),
            DB::raw('(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'),
            DB::raw('(SELECT COUNT(*) FROM `lessons`
            WHERE
                `lessons`.`section_id` IN (SELECT
                                            id
                                        FROM
                                            `sections`
                                        WHERE
                                            `sections`.`course_id` = `courses`.`id`)) as lessons_count')])
            ->get();