php - Error when executing the below query -

i trying run query. shows either 1 row or give error query result having more 1 row.

select * abc id=(select nameid xyz name '%abc%') 

help me. executing query name, father name , schoolid table abc. want school name table2 running query in in time shows 1

use in fetch more 1 row:

select * abc id in (select nameid xyz name '%abc%'); 

edit:

select a.*, x.school_name abc left join xyz x on a.id = x.nameid name '%abc%';