<?php $secondLevelmanagement = $wpdb->get_results(“SELECT * FROM $table WHERE Level=2 AND parent_id=$top_level_id”); ?>
<?php if (!empty($secondLevelmanagement)) { ?>
<div class=”organisation”>
<?php
$group=0;
$chart=array(‘individual’=>””,’group’=>array());
$chart[‘individual’]=”;
foreach ( $secondLevelmanagement as $seconduser ) : setup_postdata( $seconduser );
$id = $seconduser->team_post_id;
$thirdLevelmanagement = $wpdb->get_results(“SELECT * FROM $table WHERE Level=3 AND parent_id=$id”);
if(empty($thirdLevelmanagement))
{
$chart[‘individual’] .= ‘<div class=”chart Singlelead”>
<div class=”chartImage”>’.get_the_post_thumbnail($id, “thumbnail”).'</div>
<div class=”chartDescription”>
<h4>’.get_the_title($id).'</h4>’;
$raw_string = get_post_meta( $id, “team-member-designation”, true );
$chart[‘individual’] .= ‘<p>’.WPGlobus_Core::text_filter( $raw_string, WPGLobus::Config()->language ).'</p>
</div>
</div>’;
This is the code i am using