php提取数组中唯一值,如何从唯一值php获得单一值

我从查询中获取值

我正在寻找这样的输出：

请帮助我如何做到这一点我试图在功能上得到这个

$cols = array ('test.title', 'test_stats.*' );

$select = $db->select () ->from ( 'test', $cols )

->join ( 'test_stats', 'test_stats.test_public_id = test.test_public_id', array ())

->where ( 'test_stats.updated_on > DATE_SUB(CURDATE(), INTERVAL 1 DAY)' )

->order ( 'title' );

$result = $db->fetchAll ( $select );

foreach ( $result as $row1 ) {

$title = $row1 ['title'];

$testPublicId = $row1 ['test_public_id'];

$views = count($testPublicId);

}

$select = $db->select ()

->from ( 'test_stats', array ('count(test_public_id) AS total_views' ))

->where ( 'test_public_id = ?', $publicId );

$result2 = $db->fetchAll ( $select );

foreach ( $result2 as $row2 ) {

$totalViews = $row2 ['total_views'];

$x= '

' . $title . '

' .$testPublicId . '

' . $views . '

' . $row1 ['addr'] . '

' . $totalViews . '

';

}

}

print_r($x);