php+mysql 如何实现轮询分配值班人的功能？

将客户的报名信息INSERT先，然后取出A_I的这个ID，除以客服总人数（3个），取余（3个客服的话，余数应该为0、1、2）。

再将余数对应的客服UPDATE给这条记录。

select * from

(select t1.id-t2.min_id+1 as new_id,t1.name,t1.other

from pai_ban_biao t1

inner join (select min(id) as min_id,name from pai_ban_biao group by name )t2

on t1.name=t2.name

)t3

order by t3.new_id,t3.other

---