select a.id,a.catid,a.title,a.url,c.name as floor_name,d.name as lcspfl_name 
from `dr_1_news` a 
left join `dr_1_news_category_data` b 
on a.catid = b.catid 
left join `dr_linkage_data_3` c 
on b.floor = c.id 
left join `dr_linkage_data_4` d 
on b.lcspfl = d.id 
where c.id = 10;