mysql树形结构 jpa

@Entity
public class TreeNode {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;

    @ManyToOne
    @JoinColumn(name = "parent_id")
    private TreeNode parent;

    @OneToMany(mappedBy = "parent", cascade = CascadeType.ALL, orphanRemoval = true)
    private List<TreeNode> children = new ArrayList<>();

    // Getters and setters
}

@Repository
public interface TreeNodeRepository extends JpaRepository<TreeNode, Long> {
    @Query("SELECT t FROM TreeNode t WHERE t.id = :id OR t.parent.id = :id OR t.parent.parent.id = :id OR ...")
    List<TreeNode> findAllByAncestorId(@Param("id") Long id);
}

WITH RECURSIVE tree AS (
    SELECT * FROM tree_node WHERE id = ?
    UNION ALL
    SELECT tn.* FROM tree_node tn JOIN tree ON tn.id = tree.parent_id
)
SELECT * FROM tree;