sql自关联查询

1、子查询关联

select t.*,

(select parent_name from table where id=t.parent_id) from table t where ...(select parent_name fro