mysql - Not able to fetch data from tables -

i having following table

create table smsusers(   id varchar(60),   password varchar(50) not null,   fname varchar(30) not null,   lname varchar(30),   mailid varchar(50) not null,   gender varchar(10) not null,   primary key(id) );  create table profile_pic(   pic_id varchar(200),   profile_pic_path varchar(1000),   small_pic_path varchar(1000),   adddate varchar(100),   userid varchar(60),   foreign key(userid) references smsusers(id)       on delete cascade on update cascade,   primary key(pic_id) );  create table user_messages( messageid varchar(200), message varchar(1000), visibility varchar(100), primary key(messageid) );   create table user_message_users( messageid varchar(200), sent_to varchar(60), sent_by varchar(60), shared_of varchar(60), author varchar(60), adddate timestamp default current_timestamp, primary key(messageid,sent_by), foreign key(sent_to) references  smsusers(id) on delete cascade on update cascade, foreign key(messageid) references  user_messages(messageid) on delete cascade on update cascade, foreign key(sent_by) references smsusers(id), foreign key(shared_of) references smsusers(id), foreign key(author) references smsusers(id) ); 

here feting data above tables writing query

select       u_m.messageid,u_m.message,u_m.visibility,       u_m_u.sent_to,u_m_u.sent_by,u_m_u.shared_of,       u_m_u.author,u_m_u.adddate,       concat(usr.fname,' ',usr.lname) sender_name,       p_p.small_pic_path  user_message_users u_m_u       left join user_messages u_m         on u_m.messageid = u_m_u.messageid        left join smsusers usr         on u_m_u.sent_by=usr.id        left join profile_pic p_p         on u_m_u.sent_by=p_p.userid  group u_m_u.messageid order u_m_u.adddate desc; 

this query working here fetched messae details , sent_by's name , small_pic_path here want fetch sent_to's name , small_pic_path in query

try :

select       u_m.messageid,u_m.message,u_m.visibility,       u_m_u.sent_to,u_m_u.sent_by,u_m_u.shared_of,       u_m_u.author,u_m_u.adddate,       concat(usr.fname,' ',usr.lname) sender_name,       p_p.small_pic_path       concat(send_to_usr.fname,' ',send_to_usr.lname) send_to_name,       send_to_p_p.small_pic_path send_to_pic  user_message_users u_m_u       left join user_messages u_m         on u_m.messageid = u_m_u.messageid        left join smsusers usr         on u_m_u.sent_by=usr.id        left join profile_pic p_p         on u_m_u.sent_by=p_p.userid        left join smsusers send_to_usr         on u_m_u.sent_to=send_to_usr.id        left join profile_pic send_to_p_p         on u_m_u.sent_to=send_to_p_p.userid   group u_m_u.messageid order u_m_u.adddate desc;