paymentselect C.id,C.factory_id,C.category,F.factory from categorys C left join factorys F on C.factory_id = F.id where C.category like 'payment'