CRUDlex\MySQLData::getIdToNameMap PHP Method

    public function getIdToNameMap($entity, $nameField)
    {
        $nameSelect = $nameField !== null ? ',`' . $nameField . '`' : '';
        $drivingField = $nameField ?: 'id';
        $table = $this->definition->getServiceProvider()->getData($entity)->getDefinition()->getTable();
        $queryBuilder = $this->database->createQueryBuilder();
        $queryBuilder->select('id' . $nameSelect)->from('`' . $table . '`', 't1')->where('deleted_at IS NULL')->orderBy($drivingField);
        $queryResult = $queryBuilder->execute();
        $manyReferences = $queryResult->fetchAll(\PDO::FETCH_ASSOC);
        $result = array_reduce($manyReferences, function (&$carry, $manyReference) use($drivingField) {
            $carry[$manyReference['id']] = $manyReference[$drivingField];
            return $carry;
        }, []);
        return $result;
    }