Table 'cte_child' doesn't exist 谁能帮我解答一下，我看网上是这样写的，但是我一查就这样，不太理解

Question

WITH cte_child (id, title, parent, level)
AS (

SELECT id,
title,
parent,
0 AS level
FROM tb_menu
WHERE id = 6
UNION ALL

SELECT a.id,
a.title,
a.parent,
b.level + 1
FROM tb_menu a
INNER JOIN cte_child b
ON (a.parent = b.id)
)
SELECT *
FROM cte_child;

Answer 1

test.tree是指test数据库的tree表，确认是否准确；数据库名称可以省略的。