Magento2 - How to save custom field under admin_user table in database?

Question

I have created a custom field in admin user creation form ,how to save that field in admin_user table in Magento2?

Answer 1

I have added a new field(telephone) in the database table admin_user using the following.

Vendor/Module/etc/db_schema.xml

<?xml version="1.0"?>
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
    <table name="admin_user" resource="default" engine="innodb" comment="Admin User Table">
        <column xsi:type="varchar" name="telephone" nullable="true" length="255" comment="Admin User Telephone"/>
    </table>
</schema>

Vendor/Module/etc/adminhtml/di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <type name="Magento\User\Block\User\Edit\Tab\Main">
        <plugin name="vendor_module_admin_user_form" type="Vendor\Module\Plugin\Block\Adminhtml\User\Edit\Tab\Main" sortOrder="1"/>
    </type>
</config>

Vendor/Module/Plugin/Block/Adminhtml/User/Edit/Tab/Main.php

<?php
    namespace Vendor\Module\Plugin\Block\Adminhtml\User\Edit\Tab;

    class Main
    {
        /**
         * Get form HTML
         *
         * @return string
         */
        public function aroundGetFormHtml(
            \Magento\User\Block\User\Edit\Tab\Main $subject,
            \Closure $proceed
        )
        {
            $form = $subject->getForm();
            if (is_object($form)) {
                $fieldset = $form->getElement('base_fieldset');
                /** @var $model \Magento\User\Model\User */
                $model = $this->registry->registry('permissions_user');
                $data = $model->getData();
                $fieldset->addField(
                    'telephone',
                    'select',
                    [
                        'name' => 'telephone',
                        'label' => __('Select Telephone'),
                        'title' => __('Select Telephone'),
                        'options' => ['0' => __('--Select--'), '1' => __('Option 1'), '2' => __('Option 2'), '3' => __('Option 3')],
                        'class' => 'select',
                        'value' => isset($data['telephone']) ? $data['telephone'] : 0
                    ]
                );

                $subject->setForm($form);
            }

            return $proceed();
        }
    }

Hope this will work for you.