How to select data from joined table

Move r.id from main query to condition

PHP Code:

if ($to == 'below')
{
    $query->select('r.id')
     -> // etc
}