SELECT uss.id as id,first_name, (SELECT COUNT(*) FROM (
SELECT u.id as user_id
FROM users as u
 LEFT JOIN orders as o ON o.user_id=u.id
    LEFT JOIN plants_orders as po ON po.order_id=o.id
    LEFT JOIN plants as p ON p.id=po.plant_id
   LEFT JOIN info_plants as ip ON ip.plant_id=p.id
   WHERE user_id =uss.id
  GROUP BY o.id
  )as a)as orders
  FROM users as uss
  WHERE (SELECT COUNT(*) FROM (
SELECT ip.genus as genus
FROM users as u
 LEFT JOIN orders as o ON o.user_id=u.id
    LEFT JOIN plants_orders as po ON po.order_id=o.id
    LEFT JOIN plants as p ON p.id=po.plant_id
   LEFT JOIN info_plants as ip ON ip.plant_id=p.id
   WHERE user_id =uss.id AND genus = "Begonia"
  GROUP BY o.id
  )as a)>0
  ORDER BY orders DESC, first_name;