return session.createQuery(
                "from Category where categoryParentId = :parentId").setLong("parentId", parentId).list();
//...
<bag name="children" table="Category" inverse="true" lazy="true" fetch="select">
//..
</bag>