MySQL插入数据时查询已有数据并设置为字段值

INSERT INTO tbl_auth_paramvalue (
	paraValue,
	paraCode,
	paraName,
	paraAlias,
	orderBy,
	remark,
	deleteFlag,
	createBy,
	createDate,
	modifyBy,
	modifyDate,
	paraTypeID,
	projectNo,
	appDomainName,
	appDomainCode
)
VALUES
	(
		'自助单',
		'SELF_HELP',
		'',
		'',
		7,
		'',
		0,
		'admin01',
		'2022-11-02 16:31:06',
		'admin01',
		'2022-11-02 16:31:06',
		(
			SELECT
				a.paraID
			FROM
				(
					SELECT DISTINCT
						paraID
					FROM
						tbl_auth_paramvalue
					WHERE
						paraCode = 'domainName'
					AND paraTypeID = 0
				) AS a
		),
		NULL,
		'',
		NULL
	);
在这里插入代码片