SELECT
`u`.*,
`c`.`title` AS `city`,
`p`.`title` AS `phone`
FROM
`clients` AS `u`
LEFT JOIN
(SELECT `title`, `client_id` FROM `clients_contacts` WHERE `type` = 1) AS `c`
ON
`u`.`id` = `c`.`client_id`
LEFT JOIN
(SELECT `title`, `client_id` FROM `clients_contacts` WHERE `type` = 3) AS `p`
ON
`p`.`client_id` = `u`.`id`;