How to convert this to proper relation?

    public function actionViewInner($id)
    {

        $model = $this->loadModel($id);
        $title=Yii::t('ui',"Analogiškos prekės");

        $settings= Settings::model()->findByAttributes(array('name'=>'days_number'));
        $expire_new= time()-$settings->value*24*60*60;

        $relatedProds = Yii::app()->db->createCommand("SELECT related_prod_code FROM tbl_related_prods WHERE prod_code = :pr_kodas")->bindValue(':pr_kodas',$model->pr_kodas,PDO::PARAM_STR)->queryAll();
        $relatedProds_new = array();

        foreach($relatedProds as $value) { $relatedProds_new[] = $value['related_prod_code']; }
        $mysql_array = "('".implode("','",$relatedProds_new)."')";

        $criteria=new CDbCriteria();
        $criteria->condition = "pr_kodas IN $mysql_array";
        $dataProvider= new CActiveDataProvider('AtsargineDalis',array(
            'criteria'=>$criteria
        ));

        $this->render('view_inner',array(
            'model'=>$model,
            'dataProvider'=>$dataProvider,
            'title'=>$title,
            'active_id'=>$id,
            'expire_new'=>$expire_new,
        ));

    }