fetch data from table with relation one many but only one from relation table code example

Example: mysql relationships between tables

FOREIGN KEY (column) REFERENCES table(column)