$sql = "SELECT *,(CASE
WHEN key_answer = '0' THEN '无响应'
WHEN key_answer = '1' THEN '关键词拦截'
WHEN key_answer = '3' THEN '营销电话拦截'
WHEN key_answer = '2' AND recall = '0' THEN '来电转接'
WHEN key_answer = '2' AND recall = '2' THEN '电话留言'
END )
FROM tb_call WHERE id = '" . $_GET['id'] . "'";
以上操作节省了sql查出来之后再去foreach之类的步骤.