无法从MySQL查询得到所需的结果

I am trying to write a query in MySQL with output in PHP, but it's proving rather difficult.I am trying to write a query in MySQL with outp