sql query error when using "with" I got an an error like 1064 syntax error

with firstcte (first_name,active) as(
 select first_name,active from customer)
 select * from firstcte 

Error Code: 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 'firstcte (first_name,active) as( select first_name,active from customer) select ' at line 1 0.000 sec