当oracle中的值不为空时，选择父项的父项

WITH recursive_query AS (
  SELECT 
    child.id,
    child.name,
    parent.id AS parent_id,
    parent.name AS parent_name,
    LEVEL AS hierarchy_level
  FROM 
    your_table child
  JOIN 
    your_table parent ON child.parent_id = parent.id
  WHERE 
    child.value IS NOT NULL
  CONNECT BY PRIOR parent_id = child.id
)
SELECT 
  id,
  name,
  parent_id,
  parent_name,
  hierarchy_level
FROM 
  recursive_query;