How to write an ORM request correctly?

Question

Laravel

There is a base with such structure

Base scheme

It is necessary to pull out from the table visitllist 10 last visits of the client, with the given id.
It turns out that you need to find the last active subscription from the client, and already pull out visits from him. How to implement correctly I do not quite understand.
If suddenly the connections are not correct, I will be criticized again. MB some intermediate tables need to be added, or fields

Answer 1

where is your visitlog table? visitlist?
what is userticket_id and staff_id ? what's in users and what's in ticketslists ?
you need to name user_id and ticketslist_id