$db = \Gateway\Core\Gateway::getDBProvider();
        $db->clear();
        $db->addColumn("name", "name", "c");
        $db->addColumn("parentID", "parentid", "c");
        $db->addColumn("name", "parent", "p");

        $db->addTable("company", "c");
        $db->addLeftJoin("company", "c.parentID", "companyID", "p");
        $db->addConstraint("companyID", $this->companyID, "=", "c");

        $results = $db->select();