alias('d') ->join(['constant'=>'e'], 'd.exam_class_id = e.id') ->where('d.id',$deviceId) ->value('e.constant_value'); return $name; } }