mysql 获取所有父级

with recursive t as
(
select * from jk_his_kszdb where sid = '114'
union all
select a.* from jk_his_kszdb a join t on a.sid = t.parent_id
)
select * from t