How to get user firstname corresponding with Manage from Users

[gagan94]

Dear All,

How we can get user firstname, user last name, manager firstname,manager lastname.

I tried to create this query but not getting any data however data exist in database.

select u1.firstname,u1.lastname,u1.username,u2.firstname,u2.lastname,u2.username from users u1,users u2 where u1.owner=u2.userkey

[rushikeshvartak]

select
u.username AS 'Username',
u.FIRSTNAME as 'First Name',
u.LASTNAME AS 'Last Name',
u.Companyname as company,
u.employeetype as employeetype,
u.CREATEDATE as 'date created',
m.username AS 'Manager Username',
m.displayname as 'Manager Name',
u.OWNER as Owner
from users u,
users m
where u.manager = m.userkey
and u.statuskey = 1