Mysql树查询，查询所有的子级（不包括自己），查询所有的父级（不包括自己）

1、查询所有的子级（不包括自己）

			SELECT tp1.*
          FROM (
              SELECT * FROM energy_consumption_model_subitem
          ) tp1,
          (SELECT @id := 1242899347063050240) tp2
            WHERE ((FIND_IN_SET(parent_Id,@id) >0
            AND @id := CONCAT(@id, ',', id)));

2、查询所有的父级（不包括自己）

	SELECT t2.* FROM (
            SELECT
               @R AS temp_id,
               (SELECT @R := parent_id FROM energy_consumption_model_subitem WHERE id = temp_id) AS parent_id,
               @L := @L + 1 AS lvl
            FROM
            (SELECT @R := 1242899347063050240, @L := 0) VARS,
            energy_consumption_model_subitem tp
            WHERE @R <> 0
        ) t1
        INNER JOIN energy_consumption_model_subitem t2 ON t1.temp_id = t2.id
        ORDER BY t1.lvl DESC