SELECT
id,
nombre
FROM
(
SELECT 1 AS id, 'Lunes' AS nombre
UNION
SELECT 2 AS id, 'Martes' AS nombre
UNION
SELECT 3 AS id, 'Miércoles' AS nombre
UNION
SELECT 4 AS id, 'Jueves' AS nombre
UNION
SELECT 5 AS id, 'Viernes' AS nombre
UNION
SELECT 6 AS id, 'Sábado' AS nombre
UNION
SELECT 7 AS id, 'Domingo' AS nombre
)aux