1、字符串拼接：

update products a,categorys b set a.categoryNumbers = concat(b.parent,",",a.categoryId,",")
where b.id = a.categoryId