UserFactory::getUserFromDb

protected function getUserFromDb(int $id): ?array
{
	$query = UserTable::query()
		->setSelect(self::COMMON_SELECT_FIELD)
		->setLimit(1)
		->where('ID', $id)
		->registerRuntimeField(
			'STATUS',
			new Reference(
				'STATUS',
				StatusTable::class,
				Join::on('this.ID', 'ref.USER_ID'),
				['join_type' => Join::TYPE_LEFT]
			)
		)
	;

	if (Loader::includeModule('intranet'))
	{
		$query->addSelect('UF_DEPARTMENT');
	}

	return $query->fetch() ?: null;
}