SELECT DISTINCT
@r AS _id,
(SELECT @r := pid FROM sys_resource WHERE id = _id) AS pid
FROM
(SELECT @r := '8a2c25fe-1dfd-4875-b417-2b99e8bff624') vars,
sys_resource
WHERE @r IS not NULL
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE sys_resource
(id
varchar(100) NOT NULL,name
varchar(50) DEFAULT NULL COMMENT '资源名称',type
varchar(20) DEFAULT NULL COMMENT '资源类型',priority
int(11) DEFAULT NULL COMMENT '显示顺序',pid
varchar(100) DEFAULT NULL COMMENT '父id',permission
varchar(255) DEFAULT NULL COMMENT '权限字符串',status
varchar(20) DEFAULT NULL COMMENT '是否有效',url
varchar(255) DEFAULT NULL,art_type
varchar(255) DEFAULT NULL,pic
varchar(255) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统资源表';