mysql query error

Hi,i have some query problems.

table name : [B]USER[/B]

this is my table details:

lastname | firstname
——————–

mani | raja

raja | guru
——————–

Here guru’s father ins raja. and raja’s father is mani.so guru’s grandfather is mani. now how can i get [B]guru’s grandfather name(mani) in query.[/B]
now i know only name(guru).

pl hlp

Also in #PHP _↴