update select

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