How to Left Join between custom and MODX default tables?

$query = $modx->newQuery('modTemplateVarResource');
$query->leftJoin('MyClass', 'MyClass');

$query->where('???');

$results = $modx->getCollection('modTemplateVarResource', $query);

select * FROM
	ssm_companies
LEFT JOIN 
	modx_site_tmplvar_contentvalues 
ON 
	modx_site_tmplvar_contentvalues.value LIKE ssm_companies.id
WHERE
	modx_site_tmplvar_contentvalues.contentid IS NOT NULL

<?php
$path = MODX_CORE_PATH . 'components/myPackageName/';
$result = $modx->addPackage('myPackageName',$path .
    'model/','ssm_');
    
$query = $modx->newQuery('Companies');
$whereArray = array(
    'active'=>1
);
$query->where($whereArray);
$query->sortby('company_name','ASC');
$query ->leftJoin('Companies', 'SiteTmplvarContentvalues', array('Companies.id=SiteTmplvarContentvalues.value'));

$companies = $modx->getCollection('Companies',$query);

foreach($companies as $company) {
    $co_details = $company->toArray();
    $output .= $company->get('value');
    $output .= $modx->getChunk('tpl.company-row-pdo', $co_details);
}

return $output;

$query->leftJoin('modTemplateVarResource', 'TVR', array(
    'Companies.active => 1,
    'Companies.id' => 'TVR.value',
    /* 'TVR.contentid:!=' => null, */
));

$query->prepare();
$sqlString = $query->toSql();

<?php
$path = MODX_CORE_PATH . 'components/myPackageName/';
$result = $modx->addPackage('myPackageName',$path .
    'model/','ssm_');
    
/*SETS COLLECTION TO GET ALL COMPANIES*/
$query = $modx->newQuery('Companies');
$query->limit(15);

$query->leftJoin('modTemplateVarResource', 'TVR', array(
    'Companies.id' => 'TVR.value',
));
$query->select($modx->getSelectColumns('Companies','Companies','co_',array('id','company_name')));

$whereArray = array(
    'active'=>1
);
$query->where($whereArray);
$query->sortby('company_name','ASC');

// prepare and dump the SQL to the log
$query->prepare();
$modx->log(xPDO::LOG_LEVEL_ERROR, $query->toSql());

$companies = $modx->getCollection('Companies',$query);


foreach($companies as $company) {
    $co_details = $company->toArray();
    $output .= $modx->getChunk('tpl.company-row-pdo', $co_details);
}
return $output;

SELECT `Companies`.`id` AS `Companies_id`, `Companies`.`ticker` AS `Companies_ticker`, `Companies`.`company_name` AS `Companies_company_name`, `Companies`.`company_description` AS `Companies_company_description`, `Companies`.`exchange` AS `Companies_exchange`, `Companies`.`active` AS `Companies_active` FROM `ssm_companies` AS `Companies` LEFT JOIN `modx_site_tmplvar_contentvalues` `TVR` ON `Companies`.`id` = 0 WHERE `Companies`.`active` = 1 ORDER BY company_name ASC LIMIT 15 

$query->select($modx->getSelectColumns('Companies','Companies','co_',array('id','company_name')));

$fields = $modx->getFields('Companies');
print_r($fields);

 Array ( [id] => [ticker] => [company_name] => [company_description] => [exchange] => [active] => 1 )