SQL WITH RECURSIVE 语句中 WHERE 子句使用单引号问题

该语句中的错误在于 WHERE 子句中的 id 字段值应该用单引号括起来，而不是双引号。正确的写法如下：

WITH RECURSIVE dept_tree AS ( SELECT id, pid FROM sys_dept WHERE id = '3a7193dd6001e3b931ae69bc3383ad1b' UNION ALL SELECT d.id, d.pid FROM dept_tree dt JOIN sys_dept d ON dt.pid = d.id ) SELECT id FROM dept_tree;