UPDATE
test_database.table_1,
(
SELECT
ID,
MAX(READ_NUM) AS READ_NUM
FROM test_database.pvClick
WHERE
MEDIA_TYPE = 'WB'
AND DATETIME >= '2019-01-01 12:42:33'
AND ITEM_NAME = 'READ_NUM'
GROUP BY ID
) AS tmp
SET table_1.READ_NUM= tmp.READ_NUM
WHERE table_1.BIZ_ID = tmp.BIZ_ID