Bitrix ORM: How to use JOIN to reduce the number of requests?

Question

1C-Bitrix

I get the elements of the infoblock and the value of their property of the "List" type.

use Bitrix\Iblock\ElementTable;
use Bitrix\Iblock\PropertyEnumerationTable;
use Bitrix\Iblock\ElementPropertyTable;

$idArray = [];
$resultObj = ElementTable::getList([
  'select' => ['ID'],
  'filter' => ['IBLOCK_ID' => 1, "IBLOCK_SECTION_ID" => 1, 'ACTIVE'=>'Y'],
]);
while ($rowArray = $resultObj->fetch()) {
  $idArray[] = $rowArray['ID'];
}

$idElementArray = [];
$resultObj = ElementPropertyTable::getList([
  'select' => ['VALUE'],
  'filter' => [
            'IBLOCK_ELEMENT_ID' => $idArray,
            'IBLOCK_PROPERTY_ID' => 1 
        ], 
]);
while ($rowArray = $resultObj->fetch()) {
  $idElementArray[] = $rowArray['VALUE'];
}

$resultObj = PropertyEnumerationTable::getList([
  'select' => ['VALUE'],
  'filter' => ['ID' => $idElementArray],
]);
while ($rowArray = $resultObj->fetch()) {
  $arResult[$rowArray['ID']] = $rowArray['VALUE'];
}

How to use JOIN in this code example to reduce the number of requests?
UPD:
In the end it turned out like this. Can't optimize?

$idArray = [];
    $resultObj = ElementTable::getList([
        'select' => ['ELEMENT_PROPERTY.VALUE'],
        'filter' => ['IBLOCK_ID' => 1, "IBLOCK_SECTION_ID" => 1, 'ACTIVE'=>'Y'],
        'runtime' => [
            new Reference(
                'ELEMENT_PROPERTY',
                ElementPropertyTable::class,
                Join::on('this.ID', 'ref.IBLOCK_ELEMENT_ID')
            ),
        ],
    ]);
    while ($rowArray = $resultObj->fetch()) {
        $idArray[] = $rowArray['IBLOCK_ELEMENT_ELEMENT_PROPERTY_VALUE'];
    }

    $resultArray = PropertyEnumerationTable::getList([
        'select' => ['VALUE'],
        'filter' => ['ID' => array_unique($idArray)],
    ])->fetchAll();

Answer 1

At runtime, you can pass as many references as you like.
I will give a small example, only I use non-get lists, the Query object:

$query  = \Entities\Marketing\PostingTmpTable::query()
             ->registerRuntimeField('CONTACT', [
                 'data_type' => '\Bitrix\Sender\ContactTable',
                 'reference' => [
                     '=this.CONTACT_ID' => 'ref.ID',
                 ],
//                 'join_type' => 'right'
             ])
             ->registerRuntimeField('PROPERTY', [
                'data_type' => $hlBlockEntity,
                'reference' => [
                    '=this.CONTACT.CODE' => 'ref.UF_EMAIL'
                ],
//                 'join_type' => 'right'
            ])
        ;