With request in Eloquent doesn't work & recognize

[AmaurySchmitt]

• Laravel Version: 8.12
• PHP Version: 8.0
• Database Driver & Version: Mysql v5.7.34

Description:

I have a problem with my request, the request doesn't recognized WITH(). I work on Ubuntu & MySQL, can I get help please!

DB::select(DB::raw("WITH liststudentsoff as (
        SELECT tbl_etudiants.*, tbl_cours.idCours FROM dependance_groupes
        inner join tbl_etudiants on tbl_etudiants.idStudent = dependance_groupes.studentID
        inner join tbl_cours on tbl_cours.groupID = dependance_groupes.groupID
        inner join tbl_formations on tbl_formations.idFormation = tbl_cours.formationID
        )
        SELECT * FROM liststudentsoff
        LEFT JOIN tbl_absences ON liststudentsoff.idStudent = tbl_absences.studentID AND liststudentsoff.idCours = tbl_absences.coursID
        WHERE liststudentsoff.idCours = ".$request->idCours." and liststudentsoff.formationID = ".$cours->formationID.""));

Error :

 [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'liststudentsoff as (
        SELECT tbl_etudiants.*, tbl_cours.idCours FROM ' at line 1 at /var/www/html/emarge-backoffice/vendor/laravel/framework/src/Illuminate/Database/Connection.php:338)