How to retrieve database data in suitecrm

Hi all,

    How to retrieve database data in suitecrm, kindly explain code level sir.

this is :

   $User = new User(); //user table  object data
            //print_r($User);die;//user table
	$User->retrieve($bean->assigned_user_id);//this is accounts table data.

But i need to how to get project (assigned_user_id) in project table .account is same accounts how will retrieve sir help me code level sir.