以下语句出错 该怎么解决WITH RECURSIVE dept_tree AS SELECT id pid FROM sys_dept WHERE id = 3a7193dd6001e3b931ae69bc3383ad1b UNION ALL SELECT did dpid FROM dept_tree dt JOIN sys_dept d ON dtp

该语句中的错误在于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;