数据迁移:从A表select数据插入到B表
insert into table_B (id,member_id,height,weight,bmi,create_time,update_time)
(select a.id,c.member_id,a.height,a.weight,a.bmi,a.create_time,now()
from table_A a
inner join table_C on c.member_id =a.id
where c.is_deleted = 0 and a.is_deleted =0);