MySQL  遍历查询CommerceCustomer表下的 phone ，比对KuaiDiReceiver表.如果KuaiDiReceiver表没有对应的 phone字段值 就向 KuaiDiReceiver插入该数据，，sql 语句怎么写

INSERT INTO KuaiDiReceiver (name,phone,address,date,quantity)
SELECT name,phone,address,date,quantity
FROM CommerceCustomer
WHERE phone NOT IN (SELECT DISTINCT phone FROM KuaiDiReceiver);