How to persist a binary search tree in mysql

Question

What is the best way to store a binary search tree in Mysql ? Should each node be a table ?

Answer 1

Create a table with a circular reference.

CREATE mytable(
id int not null auto_increment,
parent_id int,
PRIMARY KEY (`id`)
);