select * from [tb_liuliangzt] t1 join [tb_liuliangzt] t2 on t1.i_pid=t2.i_id or t1.i_id=t2.i_id where t2.i_id=7 order by t2.i_id desc