How to remove sub-query for the same, and after that i want same result

I have one query which got result of visitors without use of sub-query how can i get last visitor's date in this query

select u.id,u.fname,u.lname,CONCAT_WS(' ',u.fname,u.lname) as fullname,u.gender,TIMESTAMPDIFF(YEAR, u.bdate, CURDATE()) as age,u.username,g.profile_image,v.userid,v.visitor_id,v.visited_time from tbl_user u inner join (select * from tbl_visitors order by visited_time desc )as v on(v.visitor_id=u.id) left join tbl_gallery_master g on(u.profile_image=g.id) group by v.userid,v.visitor_id order by v.visited_time desc

in this query i got absolutely fine record but i don't want sub query.