For example,
A pyramid retail website
The background with mysql saw two form

Table 1 is user_id and user_name
Table 2 is the id and pname

User_id in table 1 and table 2 of the id is associated with
Table 1 user_name show is the same thing and table 2 pname,

Asked how to query the hierarchy of someone now?