sql - How execute query with subqueries in zend framework -

hi need write sql zend_db_select, dont know how can write subqueries. appreciate help. thanks.

select * advert categoryid            in (              select id               `tree`               `lft` between                 (select lft tree id = '2') ,                 (select rgt tree id = '2')) 

// create main query $select = new zend_db_select();  //create subquery $subselect = new zend_db_select();  // using subquery in main query $select->where('table.field in(?)', $subselect->assemble());