How to correctly access the data of a linked table?

Question

MySQL

There is an Event table where several user ids from the Users table are recorded in one record
For example:
Journalist (id_j) - User 1,
Editor (id_red) - user 2,
Driver (id_driver) - User 3, Operator
(id_cam) - user 4
the users table
If I want : id_j.event = users.surname, id_red = user.surname etc
If only possible :
$event = Event::findone($id);
$event->users->surname;

Answer 1

So far, the issue has been resolved like this:
create a view in MySql

SELECT
  operators.username,
  journalist.username,
  driver.username
FROM event
  INNER JOIN user operators
    ON event.id_operator = operators.id
  INNER JOIN user journalist
    ON event.id_journalist = journalist.id
  INNER JOIN user driver
    ON event.id_driver = driver.id