SELECT t1.id,t1.name,t2.name as name2,t3.name as name3,t4.name as name4....
FROM first_table as t1
left join second_table as t2 on t2.code = t1.f_name,
left join second_table as t3 on t3.code = t1.l_name,
left join second_table as t4 on t4.code = t1.a_name,
.......
.....
.....