使用laravel的eloquent的mysql子查询

I was wondering how I'd execute subqueries in eloquent. here's the gist containing the subquery I want to execute and the the db that I'm using with the eloquent model structure. I was wondering how I'd execute subqueries in e