sql join query a table itself

Question

i have a table like this

 

uid

uname

pwd

cretaedby(who creates this that person id i.e uid;if u only register then ur uid and createdby same)

now my question is

you have to see your details createdby shown uname(who create it nit his id)

how to write join query to show like this

uid  uname   pwd   createdby(uid)   createdbyname(uname)

thanks in advance