How to use Query Builder SubQuery in Model

I think the query should look like this, but I don't know if a subquery would work instead of a table in the join method.

Code:

SELECT ticket.*, p.id as post_id, p.*
FROM ticket
LEFT JOIN (
    SELECT * FROM post p2 WHERE id = (SELECT id FROM post WHERE ticket = p2.ticket ORDER BY id DESC LIMIT 1)
) as p ON ticket.id = p.ticket
ORDER BY ticket.id DESC