select 구문와 count 구문을 left join 으로 동시에 출력

'plan'    table    -
no       member_id       subject
1       admin       admin_1111
2       member       member_1111
3       admin       admin_2222


'comment'    table    -
no       member_id       comment_content
1       member       member_comment_1111
2       member       member_comment_2222
3       admin       member_admin_1111


원하는    출력    -
회원    :    admin    /    총    게시물    :    2
admin_1111       member_admin_1111
admin_2222       member_admin_1111

$query = $mysqli_connect->query("select a.no, a.id, a.subject, b.no, b.id, b.content, 
(select count(no) from plan where id = 'admin') as pcount, (select count(no) from comment where id = 'admin') as ccount 
from plan a left join comment b on  a.id = b.id where a.id = 'admin' group by a.no");

$member = array();
while ($row = $query->fetch_array()){
	$member[] = $row;
	$pcounts = $row['pcount'];
        $ccounts = $row['ccount'];
	$member_id = $row['member_id'];
}


echo "회원 : " . $id . "
";
echo "총 게시물 : " . $pcounts . "
";
echo "댓글 수 : " . $ccounts . "
";


foreach($member as $row){
	echo $row['subject'] . $row['content'] . "
";
}