recursive table

[#1]

Hi Guys,

Here you are my problem:

I have a table1 of :2 fields: tracker_id , tracker_name

and

table2:  parent_id , child_id

how can I create a link them while a tracker_id could be a child_id and parent_id . I know that is  recursive table but don't know how to script it.

Thanks