SELECT t1.*, t2.* FROM `goodss` AS `t1`
inner join `goodss` AS `t2` on `t2`.`profile` in ('215/45', '225/45') and `t2`.`radius` = `t1`.`radius` and `t2`.`model` = `t1`.`model` and `t1`.`id_goods`!= `t2`.`id_goods`
WHERE (`t1`.`profile` = '225/45' OR `t1`.`profile` = '215/45') AND `t1`.`radius` =17