public static function getAllGroupCompanies($ccgr_id) {
        $sql = "
              SELECT 
                ccmp_id,
                ccmp_name 
              FROM
                ccxg_company_x_group 
                INNER JOIN ccmp_company 
                  ON ccxg_ccmp_id = ccmp_id 
              WHERE ccxg_ccgr_id = :ccgr_id
              ORDER BY ccmp_name
            ";
        return Yii::app()->db
                        ->createCommand($sql)
                        ->bindParam(":ccgr_id", $ccgr_id, PDO::PARAM_INT)
                        ->queryAll();
    }