Here is an example of how to write subquery in Joomla! 3 using JDatabase method.
<?php
// Initialize variables.
$db = JFactory::getDbo();
$subQuery = $db->getQuery(true);
$query = $db->getQuery(true);
// Create the base subQuery select statement.