Пример кода с pdoFetch

pdoFetch.php

<?
        public function getSelfCost($ingredientId, $stockId)
        {
            $pdo = $this->modx->getService('pdoFetch');
            $pdo->setConfig(array(
                'class' => 'msInventoryIngredientInfo',
                'innerJoin' => array(
                    'msInventoryIngredient' => array(
                        'class' => 'msInventoryIngredient',
                        'on' => 'msInventoryIngredient.invent_id = msInventoryIngredientInfo.invent_id'
                    )
                ),
                'select' => array(
                    'msInventoryIngredientInfo' => 'ingredient_id,count',
                    'msInventoryIngredient' => 'cost'),
                'where' => array(
                    'expired' => 0,
                    'ingredient_id' => $ingredientId,
                    'stock_id' => $stockId,
                ),
                'sortby' => 'msInventoryIngredientInfo.invent_id',
                'sortdir' => 'ASC',
            ));
            $ingredients = $pdo->run();
            $output = array();
            foreach($ingredients as $ingredient){

            }

        }