How to write SubQuery in Laravel 5.8 ?

I want to write subquery in laravel 5.8, what are the ways and which one is best ? I need to convert below query into laravel query. -

SELECT "assetId",id,
    (
        SELECT recording.usage from recording where recording."assetId"=asset.id ORDER BY id DESC LIMIT 1
    )
FROM asset;