Laravel 4 query -

is possible execute in eloquent?

select (select `name` `players` `player_id`=`id`) `name`, `value` `player_skills` `skillid`=0 

this looks simple relationship, can this:

playerskill::with('player')->where('skillid',0)->get();