查询当前组织其下所有子组织 SQL语句

String sql = new StringBuffer("select  {n.*} from ")
	.append("PUB_STRU n ")
	.append("CONNECT BY PRIOR n.STRU_ID=n.PARENT_ID START WITH n.PARENT_ID =?")
	.toString(); 
	List sids = new ArrayList();
    Iterator it = dao.findBySQLQuery(sql, struId, "n", PubStru.class).iterator();
        while(it.hasNext()) {
        	sids.add(((PubStru) it.next()).getStruId());
        }
return sids;