您只需要对您的条件进行分组,
SELECt ...FROM ...WHERe (a.`id` = b.`id`) AND ( b.`product-id` LIKE "%car%" OR b.`name` LIKE "%car%" OR b.`branch` LIKE "%car%" OR b.`description` LIKE "%car%" )

您只需要对您的条件进行分组,
SELECt ...FROM ...WHERe (a.`id` = b.`id`) AND ( b.`product-id` LIKE "%car%" OR b.`name` LIKE "%car%" OR b.`branch` LIKE "%car%" OR b.`description` LIKE "%car%" )