How to convert data?

Question

PHP

Good evening! In the database, in the column "Organization" is the ID of the organization, for example 13 - Employment Center, how to make the Conclusion to the site not the number 13 itself, but so that it has already converted the number 13 to the employment center?
Thanks for the answer,
I will curse good for the answer :3

Answer 1

SELECT t1.*, t2.name FROM table1 as t1 LEFT JOIN organization as t2 ON t1.organization_id = t2.id

Answer 2

Actual :3