Overgrown SQL... I see a problem, but I can't find a solution. Can you help?

Question

MySQL

There is a request:

$query = "SELECT `id`, `header`, `text`, `content`, `img`, (SELECT surname FROM personal WHERE id = (SELECT id_employee FROM news WHERE news.id_employee = personal.id) LIMIT 1) AS surname, `status`, `period` FROM `news`";

There are tables:
1) news


2) personal The


query outputs data to a table on the page:


How to write a query to:
In the "author" column from the table on the page, display the employee's last name from the personal table from the row with id = id_employee ?

(if you remove LIMIT 1 from the query, there will be an error that the query returns more than one row)

Answer 1

SELECT 
    news.`id`, 
    news.`header`, 
    news.`text`, 
    news.`content`, 
    news.`img`, 
    personal.surname, 
    news.`status`, 
    news.`period` 
FROM `news`
JOIN personal ON (personal.id = news.id_employee)

Answer 2

SELECT ..., p.surname FROM `news` n JOIN personal p ON (p.id = n.id_employee)