CTEs not working with outer references

CREATE TABLE `users` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `parent_id` int(10) unsigned DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SELECT *

FROM `users`

WHERE (

  WITH RECURSIVE `cte` AS (

    SELECT * FROM `users` AS `alias` WHERE `alias`.`parent_id` = `users`.`id`

    UNION ALL

    SELECT `users`.* FROM `users` INNER JOIN `cte` ON `cte`.`id` = `users`.`parent_id`

  )

  SELECT count(*) FROM `cte`

) > 10