试试这个：
SELECt `customer`.*, `ca1`.`value1` AS `wedding_date`, `ca2`.`value1` AS `test` FROM `customer` LEFT JOIN `customer_attributes` AS `ca1` ON customer.customerID = ca1.customerID AND ca1.key1='wedding_date'LEFT JOIN `customer_attributes` AS `ca2` ON customer.customerID = ca2.customerID AND ca2.key1='test'WHERe (customer.customerID = '58029')
将ca1 / ca2上的2个WHERe条件移到JOIN条件中，应对其进行排序
