illegal mix of collations (utf8mb4_0900_ai_ci,implicit) and (utf8mb4_general_ci,implicit) for operat

背景

今天在做MySQL的关联查询的时候，出现了如下的错误：
我的查询SQL：

select * from house as c
left join house_info as d
on c.guid =  d.guid
where c.guid in ('5050893b-4748-4db9-8b37-523ce483e4bd','2fb1dc01-3aed-4cba-b513-5568da8d72b2','d