here is the normal rows coming 

![WhatsApp_Image_2019-11-04_at_2_32_36_PM.jpeg](/attachments/large/4/f5be1a527695a5bf62797e287c220820.jpeg)

i want to show the group by product name with the count of store as the below picture

![WhatsApp_Image_2019-11-04_at_3_28_58_PM.jpeg](/attachments/large/4/b96ff7cb890fb01e6de9e5540a7e7a9e.jpeg)

here are mysql query 

SELECT
i.barcode,
i.name,
u.company_name,
COUNT(i.id) AS IQTY,
COUNT(U.id) AS UQTY
FROM
inventory i,
USER u

I suggest you post your schema and data here. Whatever you posted above isn't of any help. Keep in mind that if anyone wants to run a test against your schema/data it is much easier to set up the test when we can copy/paste data - something we can't do from a jpg screencap.